【mysql 错误】1030 Got error 28 from storage engine

【mysql 错误】1030 Got error 28 from storage engine

My /tmp was %100. After removing all files and restarting mysql everything worked fine.

今天碰到数据库出错

Got error 28 from storage engine

查了一下,数据库文件所在的盘应该没事,应该是数据库用的临时目录空间不够,引用磁盘临时空间不够导致。

解决办法:
清空/tmp目录,或者修改my.cnf中的tmpdir参数,指向具有足够空间目录