Scheduled Table Checking

We recommend that you take steps to perform regularly scheduled table checks on your database files. This can be done by wrapping isamchk/myisamchk/mysqlcheck commands into a script that is executed periodically from cron or some other scheduling software.

You may also want to modify your system boot procedure to check tables at boot time. This is especially useful when you reboot the system after a system crash.

Get Managing & Using MySQL, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.