marrowyung
asked on
MySQL loading test
Dear all,
We will undergo MySQL loading testing after migrating from MySQL 5.0 to 5.5, after that we might like to do some loading test.
We will find some slow query from the slow query log and then do the load test based on these query.
Based on you all expereience, how can we load simulate that ? any tools you guys will use ?
or if we find slow query from the slow query log is not a good idea at the beginning, what you guy will do usualy ?
We will undergo MySQL loading testing after migrating from MySQL 5.0 to 5.5, after that we might like to do some loading test.
We will find some slow query from the slow query log and then do the load test based on these query.
Based on you all expereience, how can we load simulate that ? any tools you guys will use ?
or if we find slow query from the slow query log is not a good idea at the beginning, what you guy will do usualy ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each stage. It works as if multiple clients are accessing the server. mysqlslap is available as of MySQL 5.1.4.
http://dev.mysql.com/doc/refman/5.1/en/mysqlslap.html