今天系统突然有个表无法查询,查询时会报
mysql> select * from client_info where CLIENT_NO=261889;
ERROR 1030 (HY000): Got error 134 from storage engine
一般这种情况,只要将出故障的表 执行以下操作即可:
mysql> REPAIR TABLE client_info;
+-----------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-----------------------+--------+----------+----------+
| freeiris2.client_info | repair | status | OK |
+-----------------------+--------+----------+----------+
1 row in set (5.77 sec)
mysql> select * from client_info where CLIENT_NO=261889;
Empty set (0.00 sec)
就可以了,经过测试,放心使用..