Posted by & filed under MySQL.

Maatkit is one of the great Open Source tools (among Percona Server, Xtrabackup and so on…) published by Percona. It’s a collection of utilities that help MySQL DBAs in many redundant, complex or boring tasks. For example :

  • mk-query-digest that outputs a digest of the queries from a slow-query logfile or from a running MySQL server,
  • mk-slave-delay that could help you to keep a copy of your databases while rolling back a new version of your application,
  • mk-parallel-dump and mk-parallel-restore to speed up your dump/load processes,
  • mk-table-checksum that checks the consistency of your MySQL slave,

If you’re a MySQL DBA that runs Debian servers, you really should install the new Maatkit packages from Dotdeb and read its documentation. There is a tool that will help you on your daily usage of MySQL, for sure!

Trackbacks/Pingbacks

  1.  Expert PHP – Configurer un serveur web performant : NGINX, PHP5-FPM, MySQL 5.1, Redis, Pinba sur une Debian Squeeze
  2.  Configurer un serveur web performant : NGINX, PHP5-FPM, MySQL, Redis, Pinba sur une Debian Squeeze