MySQL Swiss Army Knife

on
Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

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.

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

4 thoughts on “MySQL Swiss Army Knife

  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

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

recent

Last Tweets Last Tweets

Locations of visitors to this page
categories