Mysql Table is marked as crashed and should be repaired

查看Mysql数据库日志：/var/log/mysqld.log，发现存在以下日志内容：

[ERROR] [MY-013134] [Server] Table './TestDB/TestTable1' is marked as crashed and should be repaired

解决方法：

# mysql -uroot -p

# use TestDB;

# check table TestTable1;

mysql> check table TestTable1;
+---------------------------+-------+----------+-----------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------------+-------+----------+-----------------------------------------------------------+
| TestDB.TestTable1 | check | warning | Table is marked as crashed |
| TestDB.TestTable1 | check | warning | 14 clients are using or haven't closed the table properly |
| TestDB.TestTable1 | check | error | Record at pos: 278780 is not remove-marked |
| TestDB.TestTable1 | check | error | record delete-link-chain corrupted |
| TestDB.TestTable1 | check | error | Corrupt |
+---------------------------+-------+----------+-----------------------------------------------------------+
5 rows in set (0.01 sec)

#repair table Test_Table;
mysql> check table  Test_Table;
+---------------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+---------------------------+-------+----------+----------+
| TestDB.TestTable1 | check | status | OK |
+---------------------------+-------+----------+----------+
1 row in set (0.00 sec)