查看log发现mysql有一个表有错误
# tail /var/log/mysqld.log
151214 15:04:25 [ERROR] Got error 134 when reading table './gdwhtnew/wht_arccache'
151214 15:04:38 [ERROR] Got error 134 when reading table './gdwhtnew/wht_arccache'
151214 15:04:38 [ERROR] Got error 134 when reading table './gdwhtnew/wht_arccache'
151214 15:04:39 [ERROR] Got error 134 when reading table './gdwhtnew/wht_arccache'
151214 15:04:45 [ERROR] Got error 134 when reading table './gdwhtnew/wht_arccache'
151214 15:04:46 [ERROR] Got error 134 when reading table './gdwhtnew/wht_arccache'
151214 15:05:25 [ERROR] Got error 134 when reading table './gdwhtnew/wht_arccache'
151214 15:05:34 [ERROR] Got error 134 when reading table './gdwhtnew/wht_arccache'
151214 15:05:37 [ERROR] Got error 134 when reading table './gdwhtnew/wht_arccache'
151214 15:06:17 [ERROR] Got error 134 when reading table './gdwhtnew/wht_arccache'
在mysql命令行进行修复
mysql> use gdwhtnew;
No connection. Trying to reconnect...
Connection id: 359631
Current database: *** NONE ***
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> repair table wht_arccache;
+-----------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-----------------------+--------+----------+----------+
| gdwhtnew.wht_arccache | repair | status | OK |
+-----------------------+--------+----------+----------+
1 row in set (0.00 sec)
