Table Problems

• MyISAM may get corrupted tables if any of the following events occur:
  • The mysqld process is killed in the middle of a write.
  • An unexpected computer shutdown occurs.
    • For example, the computer is turned off.
  • Hardware failures.
  • myisamchk is modifying at the same time the table is being modified by the server.
  • A software bug in the MySQL or MyISAM code.

• Symptoms of corrupted tables include:
  • Queries that do not find rows in the table or return incomplete results.
  • Error messages asking to repair a table while selecting data from it.

• Determine whether a table became corrupted as a result of a server crash by looking for a recent restarted mysqld message in the error log.

• When mysqld is not running, check or repair a table with the myisamchk command.
  • Otherwise, use the CHECK TABLE statement to check the health of a MyISAM table.
  • Repair a corrupted MyISAM table with REPAIR TABLE.

Are there any problems from MyISAM tables not being closed properly?

---

---

© 2007 John Michael Pierobon

Notes