MYSQL优化后导致表崩溃

昨天对数据表进行优化后,竟然导致表崩溃:

mysql> OPTIMIZE TABLE plan;
+---------------------+----------+----------+-------------------------------------------------------------------------------------------------+
| Table               | Op       | Msg_type | Msg_text                                                                                        |
+---------------------+----------+----------+-------------------------------------------------------------------------------------------------+
| showcase.plan | optimize | error    | 1 when fixing table                                                                             |
| showcase.plan | optimize | Error    | Can't change ownership of the file '*********************************' (Errcode: 1) |
| showcase.plan | optimize | status   | Operation failed

myisamchk

 

你应该把MYISAM迁移到INNODB吗?

 

posted @ 2016-12-25 17:50  371502685  阅读(241)  评论(0编辑  收藏  举报