Table Maintenance

• MyISAM table maintenance can be done using SQL statements.
  • To check or repair MyISAM tables, use CHECK TABLE or REPAIR TABLE.
  • To optimize MyISAM tables, use OPTIMIZE TABLE.
  • To analyze MyISAM tables, use ANALYZE TABLE.

• The myisamchk utility gets information about database tables or checks, repairs, or optimizes them.
  • myisamchk works with MyISAM tables.
  • Tables that have .MYD and .MYI files for storing data and indexes.

• Invoke myisamchk like this:

  myisamchk [options] tbl_name
  

  • By default, myisamchk with no options simply checks the table.
  • To get a list of options use myisamchk --help

• If using myisamchk to repair or optimize tables, always ensure the mysqld server is not using the table.
  • Tables may become corrupted if the server and myisamchk access the tables simultaneously.
  • Stop mysqld
    • Or at least run mysqladmin flush-tables before running myisamchk.

How does myisamchk work?

---

---

© 2007 John Michael Pierobon

Notes