tag:blogger.com,1999:blog-3247171317808202855.post2814667754811567951..comments2009-08-11T23:38:29.711-07:00roobaronhttp://www.blogger.com/profile/08420801903669108937noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-3247171317808202855.post-3020672384730934612009-08-11T23:38:29.711-07:002009-08-11T23:38:29.711-07:00

First check your open-files limit as per my test.<br />ulimit -a<br />ulimit -n 4096<br /><br />the number-of-queries = total number of queries to be run.<br /><br />concurrency = the number of concurrent (simultaneous) threads to be ran.<br />http://dev.mysql.com/doc/refman/5.1/en/mysqlslap.html#option_mysqlslap_concurrency<br /><br />Make the number-of-queries at least 10 times the concurrency

roobaronhttp://www.blogger.com/profile/08420801903669108937noreply@blogger.comtag:blogger.com,1999:blog-3247171317808202855.post-10148111114428665962009-08-11T20:59:50.297-07:002009-08-11T20:59:50.297-07:00

I tried running 400 concurrent sessions on a medium Ec2 instance and mysqlslap throws an error that cannot create thread.<br /><br />Is this some limitation of the OS?<br /><br />I would also like to know what is the difference between the number-of-queries and concurrency.<br /><br />Thanks

Dreamshttp://www.blogger.com/profile/05471420063979491374noreply@blogger.com