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.