MySQL Forums
Forum List  »  General

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

Options: ReplyQuote


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.