Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am going to do load testing on mysql server, could someone recommend good metrics to concentrate on? Any automated way(read software) of getting/tracking them?

Thank you!

share|improve this question

4 Answers 4

up vote 3 down vote accepted

If you are looking to concentrate on MySql metrics, I highly recommend you utilize mysqlreport. It's available here and will generate alot of information as well as provides a How-To interpret the results.

Link: http://hackmysql.com/mysqlreport

share|improve this answer

For stress testing you should give MySQL Super Smack a go.

Super Smack is a benchmarking, stress testing, and load generation tool for MySQL (and PostgreSQL). Super Smack was originally written by Sasha Pachev, and then hosted and maintained by Jeremy Zawodny.

As well as MySQLReport mention by @jeffp711, you should keep a close eye on your OS level stats using mpstat, vmstat and iostat

share|improve this answer

Tech Republic in, "How do I... Stress test MySQL with mysqlslap?" covered using mysqlslap for performance testing:

The mysqlslap utility makes it possible to benchmark and compare MySQL performance on different hardware, as well as accurately quantify the effect of a change in database design. This tutorial shows how you can use mysqlslap to run tests involving multiple clients, custom queries, different table engines, and much more.

Source: Techrepublic

share|improve this answer

The best metric is "how fast does your production queries run". MySQL server performance is 99% governed by how good your schema and queries are.

share|improve this answer
    
ah, unfortunately i have no control over that :( –  Alex N Jun 26 '09 at 0:49

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.