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)

posted on 2022-02-28 20:46  遠離塵世の方舟  阅读(91)  评论(0编辑  收藏  举报

导航