Menggunakan mysqlslap number-of-query: Difference between revisions

From OnnoCenterWiki
Jump to navigationJump to search
Newer edit →
Onnowpurbo (talk | contribs)
69,477 edits
Created page with "Untuk mengetes 100 concurrent user dan 10.000 query kita dapat menggunakan perintah berikut, mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --..."
 
Onnowpurbo (talk | contribs)
69,477 edits
No edit summary
Line 1: Line 1:
Untuk mengetes 100 concurrent user dan 10.000 query kita dapat menggunakan perintah berikut,
Untuk mengetes 100 concurrent user dan 10.000 query kita dapat menggunakan perintah berikut,


mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100  --number-of-queries=10000
mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100
  --number-of-queries=10000


Output mysqlslap kira-kira sebagai berikut,
Output mysqlslap kira-kira sebagai berikut,


Benchmark
Benchmark
Average number of seconds to run all queries: 9.331 seconds
Average number of seconds to run all queries: 9.331 seconds
Minimum number of seconds to run all queries: 9.331 seconds
Minimum number of seconds to run all queries: 9.331 seconds
Maximum number of seconds to run all queries: 9.331 seconds
Maximum number of seconds to run all queries: 9.331 seconds
Number of clients running queries: 100
Number of clients running queries: 100
Average number of queries per client: 100
Average number of queries per client: 100


Perhatikan bahwa waktu yang dibutuhkan biasanya akan naik di bandingkan dengan  tanpa query.
Perhatikan bahwa waktu yang dibutuhkan biasanya akan naik di bandingkan dengan  tanpa query.

Revision as of 08:41, 22 November 2021

Untuk mengetes 100 concurrent user dan 10.000 query kita dapat menggunakan perintah berikut, 

mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100
--number-of-queries=10000

Output mysqlslap kira-kira sebagai berikut, 

Benchmark
	Average number of seconds to run all queries: 9.331 seconds
	Minimum number of seconds to run all queries: 9.331 seconds
	Maximum number of seconds to run all queries: 9.331 seconds
	Number of clients running queries: 100
	Average number of queries per client: 100

Perhatikan bahwa waktu yang dibutuhkan biasanya akan naik di bandingkan dengan tanpa query.

Retrieved from "https://lms.onnocenter.or.id/wiki/index.php?title=Menggunakan_mysqlslap_number-of-query&oldid=64058"