High Performance MySQL: CH2 Benchmarking

Chapter 2 

Capturing System Performance and Status

here the author gave a script that you can use to capture the system performance

notice the use of some important SQL statements "SHOW GLOBAL STATUS ", "SHOW ENGINE INNODB STATUS", "SHOW FULL PROCESSLIST", "SHOW GLOBAL VARIABLES"

and as you can see this scripts run every 5 seconds "INTERVAL =5"

Some Tools for Benchmarking:

1- mysqlslap (http://dev.mysql.com/doc/refman/5.1/en/mysqlslap.html)

2- Percona’s TPCC-MySQL Tool

3- MySQL Benchmark Suite (sql-bench)

the author gave examples how to use these tools.