Table Maintenance Schedule

• It is a good idea to perform table checks on a regular basis rather than waiting for problems to occur.
  • It is also a good idea to enable automatic MyISAM table checking.
    • To check MyISAM tables automatically, start the server with the --myisam-recover option.

• cron can also be used to automate periodic table maintenance.
  • Here is a sample crontab entry:

    5 1 * * 0 /path/to/myisamchk --fast --silent /path/to/datadir/*/*.MYI

Let us review the chapter.

---

---

© 2007 John Michael Pierobon

Notes