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!

Temp directory

Discussion in 'General Discussion' started by mohd_007, Mar 21, 2012.

  1. mohd_007

    mohd_007 Well-Known Member

    Joined:
    Sep 22, 2007
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    56
    cPanel Access Level:
    Website Owner
    I wonder, how different is php /tmp directory(the one which is specified in php.ini) is different from mysql tmp directory(the one which is specified in my.cnf.

    What does mysql tmp directory stores, any example?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,608
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. mohd_007

    mohd_007 Well-Known Member

    Joined:
    Sep 22, 2007
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    56
    cPanel Access Level:
    Website Owner
    Thanks for the update, Actually I wanted to what is the difference between both? which files will be stored in mysql temp directory if I change the mysql directory path?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,608
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    MySQL stores temporary files for table data for MyISAM. Here's a discussion in MySQL's documentation:

    MySQL :: MySQL 5.1 Reference Manual :: C.5.4.4 Where MySQL Stores Temporary Files

    The files are going to be hidden typically starting with a . (as hidden files would be).

    PHP temporary files are almost always session files.

    Why are you asking which stores which and where they store these? Do you have a specific issue that requires this information?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. mohd_007

    mohd_007 Well-Known Member

    Joined:
    Sep 22, 2007
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    56
    cPanel Access Level:
    Website Owner
    Actually there was no specific issue, however there was a problem where mysql stopped working when the /tmp partition was full, so I just wondered if changing the mysql temp directory and keeping php temp directory to /tmp would solve the issue.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,749
    Likes Received:
    1,885
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    If the MySQL temporary files were the cause of /tmp being full, then yes, changing the MySQL temporary directory would be the best course of action. Instructions for this can be found at:

    /var/tmp full

    Thank you.
     
    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