mysql-performance-tools from baoz.net

<a href="http://baoz.net/monyog-mysql-performance-tuning/">http://baoz.net/monyog-mysql-performance-tuning/</a>

<a href="http://baoz.net/mysql-performance-monitor/">http://baoz.net/mysql-performance-monitor/</a>

<a href="http://baoz.net/use-mysql-sql-bench/">http://baoz.net/use-mysql-sql-bench/</a>

This page contains links to various tools we found helpful to use in practice.

Some tools are written by us, others by third parties, yet another ones may be shipped with your operating system you just need to find they are there.

Maatkit

mysqladmin

mysqladmin extended -i100 -r is very nice way to look how MySQL performance counters increment and it can tell you a lot about server run status.

mysqlreport

vmstat

vmstat 10 is a great tool to run and understand what system load is looking up. It is not too detailed but great for the glance view.

mysqlsla

This is nice tool to analyze slow query log. It reads bunch of different log formats and has various stats, and it was there before mk-log-parser appeared.

innotop

filefrag

filefrag is the fool to check fragmentation of the file. Ever wondered how fragmented your tablespace or table on the file level ?

iostat

iostat tool is a great help investigating/troubleshooting IO problems – it will show you amount of IOs happening per device, their type, request size as well as queue size and response time.

mpstat

mpstat is a great tool to see details on CPU usage – how are different CPUs are being used, how many interrupts the handle etc. Helps to better understand and fine tune the load.

oprofile

iohist

drtace

fincore

sysbench