mysql Incorrect key file for table ‘/tmp/#sql_xxxx_0.MYI‘； try to repair it

查看information_schema的COLUMNS表，但是出现如下问题：
root:information_schema> select * from COLUMNS;
ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_11b6_0.MYI'; try to repair it
root:information_schema> show columns from schemaname.tablename;
我试着去修复，又出现如下问题：
root:information_schema> repair table COLUMNS;
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'information_schema'

查找资料解决的问题:

原因：mysql所在liunx磁盘分区，分区磁盘空间不足导致