I trying to select or desc tables sometimes it works and sometimes I got:

ERROR 1 (HY000): Can't create/write to file '/var/tmp/#sql_c27_0.MAI' (Errcode: 2 "No such file or directory")

it worked and stop working.

Thanks.

CodePudding user response：

It seems that your disk is out of space. I'd recommend running the following commands to check to see if it has free space / free inodes:

df -h
df -ih