MYSQL-ERROR(1030 - Got error 28 from storage engine)

1、app平台提示错误：

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => select a.*,ac.type_id from qinba_article as a left join qinba_article_cate as ac on a.cate_id = ac.id where a.is_effect = 1 and a.is_delete = 0 and ac.is_delete = 0 and ac.is_effect = 1 and ac.type_id = 3 order by a.sort desc limit 8 ) [2] => Array ( [error] => Got error 28 from storage engine ) [3] => Array ( [errno] => 1030 ) ) 

2、解决方法：

在mysql中执行报错中的语句：

select a.*,ac.type_id from qinba_article as a left join qinba_article_cate as ac on a.cate_id = ac.id where a.is_effect = 1 and a.is_delete = 0 and ac.is_delete = 0 and ac.is_effect = 1 and ac.type_id = 3 order by a.sort desc limit 8

报错误：1030 - Got error 28 from storage engine

3、在系统中查看/tmp是否已经满了：

[root@localhost /]# df /tmp/

Filesystem           1K-blocks      Used Available Use% Mounted on

/dev/sda6             20315812  14877588   4389584  100% /

[root@localhost ~]# df -h

Filesystem            Size  Used Avail Use% Mounted on

/dev/sda6              20G   19G     0 100% /

4、统计/tmp大小：

[root@localhost /]# du -sh /tmp/

29M     /tmp/

看到/tmp只有29M 那么是什么占用了/ 目录空间？

笨方法：

[root@localhost /]# df -h /ww

Filesystem            Size  Used Avail Use% Mounted on

/dev/sda6              20G   14G  4.6G  76% /

通过以上命令查看/ 目录下的所有文件夹，看看是不是挂载到了/dev/sda6下边，如果是挂载到该目录下怎统计它的大小，最后处理不需要的数据腾出空间！