Discussion on:

How do I... Stress test MySQL with mysqlslap?

Hi,
is it possible to run mysqlslap over a 5.0.X database?

Good post marx..Thanks for the info.
Could you please also let me know is there any I could test the following with mysqlslap?
like how much load my system can support upto?
- Inserts per second/transactions per sec.
- Response time for interactive queries
- Response time for report generation etc..

Thankyou

Nice post Mark..Thanks for the info.
Could you please also let me know is there any I could test the following with mysqlslap?
like how much load my system can support upto?
- Inserts per second/transactions per sec.
- Response time for interactive queries
- Response time for report generation etc..

Thankyou

If I have 1 insert and 1 select statements in my Query file and I am doing
"mysqlslap -u root -p -q query.sql --iterations 100 "
Is that means total number of queries are 200.

If I give concurrency=4 .. then the total number of Query's executed by each client.. will it be 50 ?

so

mysqlslap -u root -p -q query.sql --iterations 100 --concurrency=4

is faster than

"mysqlslap -u root -p -q query.sql --iterations 100 "

Did I get anything wrong ?

--
Britto

hi Mark,

I appreciate this great doc. This is very easy to understand from our requirement wise.

While I testing using mysqlslap i got the following error ,I'm using mysql-proxy with rw-splittiing.lua to redirect the query to back end servers. This is the error :
-------------------------
mysqlslap: Cannot run query INSERT INTO t1 VALUES (1804289383,'mxvtvmC9127qJNm06sGB8R92q2j7vTiiITRDGXM9ZLzkdekbWtmXKwZ2qG1llkRw5m9DHOFilEREk3q7oce8O3BEJC0woJsm6uzFAEynLH2xCsw1KQ1lT4zg9rdxBL') ERROR : No database selected
---------------------------------

If got something from this please help me to solve this problem.
Thanks
Haridas N.

i want to run this: /usr/bin/mysqlslap -u traffic2 -p traffic2 query="select * from rc_profile_table;" -vv --concurrency=100 --iterations=5
if i add the --create-schema option what will this do? because i get an error:
/usr/bin/mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'

when i run: /usr/bin/mysqlslap -u traffic2 -p traffic2 --auto-generate-sql -vv --concurrency=100 --number-of-queries=1000 --number-char-cols=4 --number-int-cols=7 >> ~/Documents/DBLoadTest.log

i have no problems but i want to run this test on one of my actual tables please?
thank you