Symptoms Of Corrupted Tables

• Symptoms of corrupted tables include queries that abort unexpectedly and observable errors such as these:
  • tbl_name.frm is locked against change
  • Cannot find file tbl_name.MYI
  • Unexpected end of file
  • Record file is crashed
  • Got error nnn from table handler

• To get more information about an error, run perror nnn, where nnn is the error number.
  • Error 135 (no more room in record file) and error 136 (no more room in index file) are not errors that can be fixed by a simple repair.
  • Run ALTER TABLE to increase the MAX_ROWS and AVG_ROW_LENGTH table option values.

    ALTER TABLE tbl_name MAX_ROWS=xxx AVG_ROW_LENGTH=yyy;

  • To learn the current table option values, use SHOW CREATE TABLE.

How do I repair tables?

---

---

© 2007 John Michael Pierobon

Notes