In this post I present my MySQL Swiss Army Knife, all the tools that make my life related to MySQL easier 🙂
– The first utility is of course the famous maatkit. I’ll not describe here all the part of this toolkit, you will find a nice description on the website. but I want to underline the Table Sync that is very useful when you need to create a master/master replication without any downtime.
– The next utility is mysqlreport, that creates complete reports giving a nice overview of statistics for your MySQL server.
– Another very useful tool is querysniffer (and the other two related utilities: querybench and queryparser). The nice thing with this tool is that it allows you to gather the queries from a production server without having to restart it to enable general logging.
– To hunt slow queries, mysqlsla is a nice analyzer.
– mysqlidchck is also a nice tool that helps you to find the indexes that are not used in your datbase if any.
– If you are using InnoDB tablespaces, I also recommend innodb-recovery, it allows you to check and recover datat from damaged tablespaces.
– Dstat is also nice to see some information in realtime. Of course it’s not only focused on MySQL, but I wrote some plugins for MySQL5. I’d like to be able to give some signification of the output colors. It’s a call to candidates (to Dag, to any Python hacker or to me if I find more time)
– mytop is a top clone for MySQL, a console utility for monitoring the threads of a MySQL server.
– Another “top like” tool especially for innodb is innotop
– To find all the resources used by MySQL, a Perl script: mysqlresources can be used.
– There is a new package of tools but it’s still in my “totest” list, but I’ll just put a link to its page : MyQ Gadgets
I wanted also to make you share some tools which are part of my back bag :
– DB Designer Fork that runs on GNU/Linux that allows you to visually design your databases.
– MySQL Proxy permits you to monitor, analyze communications between clients and MySQL server that allows you to use it to implement load balancing, failover, query analysis, filtering and modification.