Insufficient disk space causes MySQL to fail to start MySQL error

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.