Tables Not Being Closed Properly

• Each MyISAM index file (.MYI file) has a counter in the header that can be used to check whether a table has been closed properly.
  • The following warning from CHECK TABLE or myisamchk means this counter has gone out of sync.

    clients are using or haven't closed the table properly

  • This warning does not necessarily mean the table is corrupted.

• The counter can become incorrect under these conditions:
  • A MyISAM table is copied without first issuing LOCK TABLES and FLUSH TABLES.
  • MySQL has crashed between an update and the final close.
    • The table may not have a problem, because MySQL always issues writes for everything between each statement.
  • A table was modified by myisamchk --recover or myisamchk --update-state at the same time that it was in use by mysqld.
  • Multiple mysqld servers are using the table and one server performed a REPAIR TABLE or CHECK TABLE on the table while it was in use by another server.

What is InnoDB?

---

---

© 2007 John Michael Pierobon

Notes