my two cents

mysqlslap is worth a look

mysqlslap --host=myhostname --user=myusername -p'mypassword' --create-schema=mydatabase --delimiter=';' --concurrency=10 --iterations=5 --query=/tmp/queriestobenchmark.sql

SAMPLE /tmp/queriestobenchmark.sql file

SELECT * FROM users; SELECT title FROM forum

Tags: benchmark, MySQL

This entry was posted on Monday, September 28th, 2009 at 9:07 pm and is filed under MySQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.