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!

tmp_table_size

Discussion in 'Database Discussion' started by Masimo, Feb 5, 2016.

  1. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    70
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Tbilisi
    cPanel Access Level:
    Root Administrator
    I have below errors in MySQL log today, is it need to increase "tmp_table_size" in "my.cnf"?

    Code:
    2016-02-05 17:47:23 28254 [ERROR] /usr/sbin/mysqld: Sort aborted: Error writing file '/tmp/MYWJj6hn' (Errcode: 28 - No space left on device)
    2016-02-05 17:47:24 28254 [ERROR] /usr/sbin/mysqld: Sort aborted: Error writing file '/tmp/MYw9IoMn' (Errcode: 28 - No space left on device)
    2016-02-05 17:47:27 28254 [ERROR] /usr/sbin/mysqld: Sort aborted: Error writing file '/tmp/MYxc5hpS' (Errcode: 28 - No space left on device)
    2016-02-05 17:47:27 28254 [ERROR] /usr/sbin/mysqld: Sort aborted: Error writing file '/tmp/MYzyXCAk' (Errcode: 28 - No space left on device)
    2016-02-05 17:47:27 28254 [ERROR] /usr/sbin/mysqld: Sort aborted: Error writing file '/tmp/MYTBwc5v' (Errcode: 28 - No space left on device)
    2016-02-05 17:47:27 28254 [ERROR] /usr/sbin/mysqld: Sort aborted: Error writing file '/tmp/MYQdsYIF' (Errcode: 28 - No space left on device)
    will you pls help me to point a domain to specific ip address
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 Masimo, Feb 5, 2016
    Last edited by a moderator: Feb 5, 2016
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,161
    Likes Received:
    370
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    You might want to open another thread on that issue.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,672
    Likes Received:
    1,788
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    Check to see if there's available disk space and inodes on your tmp directory. EX:

    Code:
    df -h
    df -i
    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    70
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Tbilisi
    cPanel Access Level:
    Root Administrator
    Its looking fine, any more idea?

    [root@static tools]# df -h
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. SysSachin

    SysSachin Well-Known Member

    Joined:
    Aug 23, 2015
    Messages:
    604
    Likes Received:
    42
    Trophy Points:
    28
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hi,

    Please check inodes uses. Might be inodes uses is 100 %.

    run the below command.

    df -i
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    70
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Tbilisi
    cPanel Access Level:
    Root Administrator
    Its ok!

    [root@static tools]# df -i
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,672
    Likes Received:
    1,788
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

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