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.

MySQL + /usr/tmpDSK

Discussion in 'General Discussion' started by racz, Nov 17, 2008.

  1. racz

    racz Member

    Joined:
    Jul 15, 2008
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Hi all,

    There is a very strange problem here (for me):

    Sometimes, the /tmp is become full suddenly -> php can't make session files etc.
    but
    when i restart mysql, the /tmp is become empty.
    i have 5 servers with centos+cpanel, 4 works fine, but this one is wrong with same settings.


    [​IMG]
    the /tmp usage graph: wrong-restart-ok-wrong-restart....


    Any idea?
     
    #1 racz, Nov 17, 2008
    Last edited: Nov 17, 2008
  2. racz

    racz Member

    Joined:
    Jul 15, 2008
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Anybody? give me some tips pls.
     
  3. mitul

    mitul Well-Known Member

    Joined:
    Feb 8, 2003
    Messages:
    291
    Likes Received:
    0
    Trophy Points:
    16
  4. racz

    racz Member

    Joined:
    Jul 15, 2008
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Ok thanks, it seems to work
     
  5. racz

    racz Member

    Joined:
    Jul 15, 2008
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Hmm it doesn't work. the problem have returned. I need help.
     
  6. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,447
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Have you actually looked in the /tmp directory to see what's filling it up? Who is the owner of the files in there?
     
  7. racz

    racz Member

    Joined:
    Jul 15, 2008
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    i dont know, when the /tmp seems to be filled, there are the same files. When i restart the mysql, everything became OK but i think it's not the mysql's fault.
     
  8. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    Could you provide some sample file names?

    MySQL uses /tmp when performing actions such as table and database renames, as well as certain queries. It's possible those temporary files are not being removed, for whatever reason.

    What is your MySQL version?
     
  9. racz

    racz Member

    Joined:
    Jul 15, 2008
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    mysql Ver 14.12 Distrib 5.0.67, CentOS

    file names:

    lot of: sess_ff8f45b79xxxxxxxxxxxxx - php sessions, but apache remove this after use, and these size maximum some kB.
    and the symlink of mysql.sock

    That's all files stored in /tmp


    "temporary files are not being removed, for whatever reason." - ok i see, but what could be the reason? :)
     
  10. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,447
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    How large is your tmp/ directory? You may just need to increase the size of it. The files you mention are normal, and if they're being removed then the system is working as expected I would think.
     
Loading...

Share This Page