Simulate Concurrency with mysqlslap
Posted by:
Britto I
Date: July 21, 2009 12:12AM
Hi All,
I have a Insert Query and a Select Query in Query.sql file.
If I want to test my database with 1000 Inserts and 1000 Selects then the command would be from my client
mysqlslap -u root -p -q query.sql --iterations 1000
If I want to share that load to multiple concurrent clients
mysql -u root -p -q query.sql --iterations 25 --concurrency=40
Means I was assuming the 40 clients will establish 50(1 Insert and 1 select) queries to the database server and finish faster than
"mysqlslap -u root -p -q query.sql --iterations 1000"
Actually my Assumption was wrong , without concurrency the task was faster.
Can anyone clarify on this.
Thanks in Advance.
--
Britto
Subject
Written By
Posted
Simulate Concurrency with mysqlslap
July 21, 2009 12:12AM
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.