Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

/usr/sbin/mysqld: Incorrect key file for table

Discussion in 'Database Discussion' started by gopkris2000, Jun 20, 2013.

  1. gopkris2000

    gopkris2000 Registered

    Joined:
    Apr 22, 2013
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Our mysql server keep crashed and received the following errors. We have already increased open files limit but still failed.


    130620 1:22:06 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_fa025_0.MYI'; try to repair it
    130620 1:22:06 [ERROR] Got an error from unknown thread, /home/rpmbuild/rpm-build/BUILD/mysql-5.5.31/mysql-5.5.31/storage/myisam/mi_write.c:226

    /tmp space is available.

    Any idea?
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,400
    Likes Received:
    1,952
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    This typically happens when there is not enough space in the /tmp partition to handle the temporary MySQL files. The following post provides a guide on how to change the MySQL tmp location to resolve this issue:

    Updating MySQL tmp directory

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,888
    Likes Received:
    90
    Trophy Points:
    78
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice