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