mysql - MySQL proc 表经常崩溃

Question

我的一台 MySQL 服务器经常因以下错误而崩溃。我修好了桌子，但请帮助我了解崩溃的原因并防止它发生。

    Table './mysql/proc' is marked as crashed and last (automatic?) repair failed
+------------+--------+----------+------------------------------------------------------+
| Table      | Op     | Msg_type | Msg_text                                             |
+------------+--------+----------+------------------------------------------------------+
| mysql.proc | repair | info     | Wrong bytesec: 116-114- 97 at 1849604; Skipped       |
| mysql.proc | repair | info     | Found block that points outside data file at 1856336 |
| mysql.proc | repair | info     | Wrong bytesec:  54- 53- 46 at 2513660; Skipped       |
| mysql.proc | repair | info     | Found block that points outside data file at 1900432 |
| mysql.proc | repair | info     | Found block that points outside data file at 1972664 |
| mysql.proc | repair | info     | Wrong bytesec: 116-114- 97 at 1849604; Skipped       |
| mysql.proc | repair | info     | Found block that points outside data file at 2586424 |
| mysql.proc | repair | info     | Found block that points outside data file at 2621952 |
| mysql.proc | repair | warning  | Number of rows changed from 157 to 146               |
| mysql.proc | repair | status   | OK                                                   |
+------------+--------+----------+------------------------------------------------------+

服务器是 MySQL 5.7.27 社区版，数据库有这么多的分区和存储过程。

谢谢你，彼得

标签： mysql