MySQL Swiss Army Knife

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.