mysql的error log显示：
Incorrect key file for table '/tmp/#sql_3cc8_0.MYI'; try to repair it Component not found: SQLEngineServer,
120222 7:47:15 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_7aa6_0.MYI'; try to repair it
这个错误log一度误导了我，以为是别的问题呢？看MYI也有啊，无意中看到：
/dev/xvda3 35G 33G 349M 99%
/ is full ,tmp file couldn't generate correctly ....
此外xen的VM问题很多，比如突然的power outage会导致虚拟磁盘故障，经常需要修复，还有inode满了等问题。
阅读(1283) | 评论(0) | 转发(0) |
