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.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

4 Comments

  1. Thanks for the kind mention of querysniffer and QPP programs. It is good to know that people are getting use of them!!

    Keith

Leave a Reply to lefredCancel Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

You can find articles I wrote on Oracle’s blog.