percona toolkit

Percona Toolkit

Замена maatkit-у, также может быть заменой mysqltuner.
Есть предположение, что работает только с последними версиями мускуля, в частности на штатном 5.0 может не заработать, ниже - не работает почти наверняка. Но надо проверить.


Percona Toolkit is a collection of advanced command-line tools used by Percona support staff to perform a variety of MySQL and system tasks that are too difficult or complex to perform manually, including:

Verify master and replica data consistency
Efficiently archive rows
Find duplicate indexes
Summarize MySQL servers
Analyze queries from logs and tcpdump
Collect vital system information when problems occur
Tools are a vital part of any MySQL deployment, so it's important to use ones that are reliable and well-designed. Over 4,000 tests and several years of deployment, including some of the Internet's best-known sites, have proven the reliability of the tools in Percona Toolkit. And the combined experience and expertise of Percona ensures that each tool is well thought-out and designed.

Percona Toolkit is derived from Maatkit and Aspersa, two of the best-known utility toolkits for MySQL server administration.