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 full please help

Discussion in 'Workarounds and Optimization' started by cool999, Jan 28, 2010.

  1. cool999

    cool999 Active Member

    Joined:
    Jan 18, 2010
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    6
    Problem repairing table /tmp getting full. Urgent help needed please!

    Hello, please tell me how can i clear /temp

    /usr/tmpDSK 485M 460M 16K 100% /tmp

    let me know.. thanks...
     
    #1 cool999, Jan 28, 2010
    Last edited: Jan 29, 2010
  2. cool999

    cool999 Active Member

    Joined:
    Jan 18, 2010
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    6
    i found the reason why my tmp is getting full, one my database table is crashed, and when i try to repair it, it make the tmp full, and because of this i m not able to repair my table... ( i cleared the /tmp using this cmd - rm -f -r ses* ) please help me out... can i stop it from created log / session files or whatever in tmp so i can repair my table or any other way?

    urgent help please..

    Thank you...
     
  3. anojpala

    anojpala Member

    Joined:
    Nov 29, 2005
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    I guess your database is of large size and the memory allocated for mysql is not good enough.In such situations it will try to use /tmp and if it is also full then will fail.
    Removing session files is not a good option as its of very small size.
    Either you increase the memory for mysql or increase the /tmp size. This will help whenever you need to repair that database again.
     
  4. cool999

    cool999 Active Member

    Joined:
    Jan 18, 2010
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    6
    I did this and increased my /tmp to 2 GB, and repaired my table successfully..

    Code:
    # /etc/init.d/mysql stop
    # cp -af /var/tmp /var/tmp.bak
    # umount /var/tmp
    # umount /tmp
    # rm -f /usr/tmpDSK
    # dd if=/dev/zero of=/usr/tmpDSK bs=1024 count=1048576
    # mkfs /usr/tmpDSK
    # tune2fs -j /usr/tmpDSK
    # mount -t ext3 -o nosuid,noexec,loop /usr/tmpDSK /tmp
    # mount -o bind,noexec,nosuid /tmp /var/tmp
    # cp -a /var/tmp.bak/* /tmp/
    # rm -rf /var/tmp.bak/
    # chmod 1777 /tmp
    # /etc/init.d/mysql start
    

    enjoy
     
Loading...

Share This Page