ask-sheldon.com
Check and optimize tables in MySQL | Bravehartk2's Blog
This really short snippet shows, how to check and optimize tables on MySQL servers with the mysqlcheck command line tool for all databases or a single one.