Insufficient disk space causes MySQL to fail to start MySQL error

View table hint 1030 error in MySQL:

mysql> desc User;

Error 1030 (HY000): Got error from storage engine

The cause of this error is insufficient disk space, resulting in a lack of temporary directory space for MySQL tmpdir.

The solution is to empty the/tmp directory of the Linux system, or modify the Tmpdir parameter in the MY.CNF to a directory with enough space.

Use DF to view partition usage:

[Root@jsunsa tmp]# Df/tmp

FileSystem 1k-blocks Used Available use% mounted on

/dev/sda2 3960348 3758820 0 100%/

[Root@jsunsa tmp]# DF

This column more highlights: http://www.bianceng.cn/database/MySQL/

FileSystem 1k-blocks Used Available use% mounted on

/dev/sda2 3960348 3758820 0 100%/

/dev/sda5 14270000 1864672 11668752 14%/home

/DEV/SDA1 46633 10688 33537 25%/boot

Tmpfs 273712 0 273712 0%/dev/shm

It can be seen that the utilization rate of/dev/sda2 is 100%, there is no extra space to operate, so the above problem.