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