Maatkit is a pretty useful set of utilities for MySQL. From their site:
You can use Maatkit to prove replication is working correctly, fix corrupted data, automate repetitive tasks, speed up your servers, and much, much more.
One of the first things you can do after installing the toolkit (which may already be installed if you are running CentOS or Debian) is to run the
mk-audit utility. It will give you a nice summary of your server, as well as point out potential problems in your configuration.
Here's a list of all the utilities included in Maatkit:
- mk-archiver Archive rows from a MySQL table into another table or a file.
- mk-audit Analyze, summarize and report on MySQL config, schema and operation
- mk-checksum-filter Filter