Got error 134,28 from storage engine

Got error 134 from storage engine

Got error 28 from storage engine

===============================================

MySql 执行以以下SQL时报错：

mysql> select * from service_invoker where id=336518;

错误：

ERROR 1030 : Got error 134 from storage engine

storage engine错误，一般就是表出错了吧

检查表：check table tablename;
mysql> check table service_invoker;
+----------------------------+-------+----------+-----------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------------------+-------+----------+-----------------------------------------------------------------------+
| registerdb.service_invoker | check | warning | Table is marked as crashed |
| registerdb.service_invoker | check | warning | 9 clients are using or haven't closed the table properly |
| registerdb.service_invoker | check | warning | Found 12026004 deleted space in delete link chain. Should be 12025988 |
| registerdb.service_invoker | check | error | Found more than the expected 93657 deleted rows in delete link chain |
| registerdb.service_invoker | check | error | record delete-link-chain corrupted |
| registerdb.service_invoker | check | error | Corrupt |
+----------------------------+-------+----------+-----------------------------------------------------------------------+
6 rows in set

修复表：repair table tablename;
mysql> repair table service_invoker;

+----------------------------+--------+----------+--------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------------------+--------+----------+--------------------------------------------+
| registerdb.service_invoker | repair | warning | Number of rows changed from 70677 to 64352 |
| registerdb.service_invoker | repair | status | OK |
+----------------------------+--------+----------+--------------------------------------------+
2 rows in set

mysql>

==========================================================

Got error 28 from storage engine

mysql数据库就出现了“Got error 28 from storage engine”错误，去google搜索了一下，发现问题这样解决;
磁盘临时空间不够导致。
解决办法：
清空/tmp目录，或者修改my.cnf中的tmpdir参数，指向具有足够空间目录