The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

tmp_table_size

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

  1. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    58
    Likes Received:
    0
    Trophy Points:
    6
    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
     
    #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:
    14,472
    Likes Received:
    200
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    You might want to open another thread on that issue.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,852
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  4. Masimo

    Masimo Well-Known Member

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

    [root@static tools]# df -h
     
  5. SysSachin

    SysSachin Well-Known Member

    Joined:
    Aug 23, 2015
    Messages:
    326
    Likes Received:
    24
    Trophy Points:
    18
    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
     
  6. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    58
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Tbilisi
    cPanel Access Level:
    Root Administrator
    Its ok!

    [root@static tools]# df -i
     

Share This Page