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.

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:
    6
    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?
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
  3. mohd_007

    mohd_007 Well-Known Member

    Joined:
    Sep 22, 2007
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    6
    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?
     
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    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?
     
  5. mohd_007

    mohd_007 Well-Known Member

    Joined:
    Sep 22, 2007
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    6
    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.
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page