MySQL Forums
Forum List  »  Performance

Why mysqlslap doesn't return the correct Benchmark time?
Posted by: Cai Vincent
Date: April 20, 2015 08:07AM

I try to use mysqlslap to do performance test as the below.
C:\>"E:\Program Files\MySQL\MySQL Server 5.6\bin\mysqlslap.exe" -h localhost --port=3306 --user=root -p0315 --query="select sleep(20);"
Benchmark
Average number of seconds to run all queries: 40.000 seconds
Minimum number of seconds to run all queries: 40.000 seconds
Maximum number of seconds to run all queries: 40.000 seconds
Number of clients running queries: 1
Average number of queries per client: 1

In the above script, I only make MySql to sleep 20 seconds. And during execution, it takes about 20 seconds as the expected. But according to the output of mysqlslap, it takes 40 seconds. Could anyone give me a hand on this, please? Are there any usage errors on my script?
Thank you.

My MySQL is the latest Community Edition on windows.

Options: ReplyQuote


Subject
Views
Written By
Posted
Why mysqlslap doesn't return the correct Benchmark time?
1487
April 20, 2015 08:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.