Menggunakan mysqlslap iterations

From OnnoWiki
Revision as of 15:42, 22 November 2021 by Onnowpurbo (talk | contribs)
Jump to navigation Jump to search

Untuk memastikan bahwa hasil test cukup konsisten, ada baiknya dilakukan iterasi. Mengulangi query lebih dari satu menggunakan iterations dapat menggunakan perintah,

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

Output mysqlslap kira-kira sebagai berikut,

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