mysql报错：[ERROR] /usr/libexec/mysqld: Table ‘./istester/idoxu_article' is marked as crashed and should be repaired

问：mysql报错：[ERROR] /usr/libexec/mysqld: Table ‘./istester/idoxu_article' is marked as crashed and should be repaired

解决思路：

1、进入你的 Linux下mysql 安装目录

tail -100f iZ94b31ttqsZ.err （找到这个错误日志文件）

220731  0:59:57 [ERROR] /usr/libexec/mysqld: Table './istester/idoxu_article' is marked as crashed and should be repaired

2、命令行进入 mysql

mysql -u root -p

mysql> use istester

Database changed

mysql> 

mysql> 

mysql> show tables;

3、检查损坏的表

mysql> check table idoxu_article;

+-----------------------------+-------+----------+-----------------------------------------------------------+

| Table                       | Op    | Msg_type | Msg_text                                                  |

+-----------------------------+-------+----------+-----------------------------------------------------------+

| cz_istester_com.eps_article | check | warning  | Table is marked as crashed                                |

| cz_istester_com.eps_article | check | warning  | 39 clients are using or haven't closed the table properly |

| cz_istester_com.eps_article | check | error    | Checksum for key:  4 doesn't match checksum for records   |

| cz_istester_com.eps_article | check | error    | Corrupt                                                   |

+-----------------------------+-------+----------+-----------------------------------------------------------+

4 rows in set (0.14 sec)

4、进行表修复 ，一行命令搞定 。

mysql> repair table eps_article;