MySQL Table Maintenance.

This morning I was asked by one of the other Engineers in my group about an easy way to analyze all the tables in a database. So I pointed him to mysqlcheck. Which is a great command line client for performing table mainteneance on mysql database tables. It checks, repairs, optimizes, or analyzes tables, all from the command line. Like any other program it has a ton of flags, but here are three general ways to invoke it.

shell> mysqlcheck [options] db_name [tables]
shell> mysqlcheck [options] –databases db_name1 [db_name2 db_name3…]
shell> mysqlcheck [options] –all-databases

For more information check out.

MySQL 5.0 Reference Manual :: 4 MySQL Programs :: 4.5 MySQL Client Programs :: 4.5.3 mysqlcheck — A Table Maintenance Program