MySQL Swiss Army Knife

on

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.

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 *

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

recent

Last Tweets

  • RT : 昨年開催されたOracle MySQL Innovation Day 2018 秋の模様がEnterpriseZineのDB Onlineに掲載されました / MySQL 8.0の新機能から寿司ビール問題まで――Oracle MySQL Innovation Day 2018 秋 via ,
  • If you have a ticket for the pre-FOSDEM Day and you are not able to join, please release your ticket, there are people on the waiting list ! Thank you in advance ! ,
  • When your laptop dies just before 2 weeks of conferences... ,
  • RT : EVENTS:  MySQL Day, Denver, CO Forget Skiing. On Tuesday, January 29, 2019 Denver is all about NoSQL + SQL = MySQL. Join us to learn about NoSQL+SQL, plus how to improve your database performance, secure your data and prevent downtime. Register today! ,
  • RT : MySQL is ubiquitious for cloud usage. In this series I will explore Oracle Cloud's IaaS offerings that support MySQL. In this particular post I will highlight IaaS Enterprise capabilities that help secure our cloud perimiter. ,
Locations of visitors to this page
categories