MySQL Tools

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

MySQL Report is a tool which would look at status variables same as mysqladmin extended but will group them together nicely and provide some hints on what are good and bad values.

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.

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 pt-query-digest appeared.

Innotop is great top like tool for MySQL and is helpful even if you do not use Innodb tables. Very nice to watch what happens to server in the real time.

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

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

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 is usually used for advanced MySQL tuning when the load is CPU bound – it will tell you where exactly inside MySQL or CPU time is spent.

iohist is a little tool to show histogram for IO response time. The main use for it is to see how response time is split for read and write request rather than seeing the average reported by iostat. These can be very different.

Dtrace is a great tool for system level performance analyses, with a catch of it being unavailable on which limits it practical use dramatically.

fincore is a tool to check how well given file is cached in operation system cache. Very helpful to analyze caching of MyISAM tables for example.

sysbench is a tool to check performance of system and MySQL. Helpful to check different hardware and OS characteristic.

Print Friendly, PDF & Email



Bài viết liên quan

Be the first to comment

Để lại lời nhắn