今天想优化一下表,优化之后出现了如下问题:mysql> OPTIMIZE TABLE jo_mailqueue;
+---------------------+----------+----------+-------------------------------------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------+----------+----------+-------------------------------------------------------------------------------------------------+
| jobour.jo_mailqueue | optimize | error | 1 when fixing table |
| jobour.jo_mailqueue | optimize | Error | Can't change ownership of the file '/usr/local/mysql/data/jobour/jo_mailqueue.MYD' (Errcode: 1) |
| jobour.jo_mailqueue | optimize | status | Operation failed |
+---------------------+----------+----------+---------------------------------------------------------------------------------------
从phpmyadmin打开之后,发现表正在使用中。
OPTIMIZE 优化表怎么会出现这种问题啊。是什么导致的啊。? 谢谢!
+---------------------+----------+----------+-------------------------------------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------+----------+----------+-------------------------------------------------------------------------------------------------+
| jobour.jo_mailqueue | optimize | error | 1 when fixing table |
| jobour.jo_mailqueue | optimize | Error | Can't change ownership of the file '/usr/local/mysql/data/jobour/jo_mailqueue.MYD' (Errcode: 1) |
| jobour.jo_mailqueue | optimize | status | Operation failed |
+---------------------+----------+----------+---------------------------------------------------------------------------------------
从phpmyadmin打开之后,发现表正在使用中。
OPTIMIZE 优化表怎么会出现这种问题啊。是什么导致的啊。? 谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货