?

Log in

mysqlslap, Heidelberg, multiple loops...

« previous entry | next entry »
Sep. 27th, 2007 | 06:08 pm

Last week was the MySQL developers meeting. Since MySQL is a virtual company, I don't get a chance for direct feedback all that often from a room full of developers.

I ended giving three University sessions during the week. The only new one was on MySQL Slap (the rest of my talks were on Storage Engines and plugins). You can find the presentation here:
http://forge.mysql.com/w/images/8/82/Mysqlslap.pdf

The presentation is just a bunch of bullet notes, I am told that they taped it and that a video will be coming out shortly (do not miss the one where I broke the glass mid session!).

BrianM had asked me a while ago about adding support to run multiple tests at the same time. This is what I have figured out so far:


./mysqlslap --only-print --concurrency=5 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=write,read:4


As you can see, you can specify multiple load tests to be run at once. The parameter "4" means to multiply the concurrency by that number (so you can have more of one test). The above would generate 5 write tests, and 20 read tests. At the moment there are only a few "generators" but I will be adding more/adding some way for users to dynamically create them.

I am thinking about extending the syntax to files as well. So if you are writing your own tests you could do a:
--query=filename1,filename.sql:3
and have essentially the same as above. This would greatly extend the current flexibility.

Link | Leave a comment | Share

Comments {1}

Tanjent

spherical projector.

from: tanjent
date: Sep. 30th, 2007 08:02 am (UTC)
Link

i figure this is an easy way to get in touch - details and pics of project applecore are on my lj.

personal email is tanjent at gmail.

-tanjent

Reply | Thread