The Planet Forums > Size of partition for /tmp

Full Version: Size of partition for /tmp

The Planet Forums > System Administration > Other

Vatoloco

Nov 20 2007, 04:03 PM

I have a mysql database that is about 5GB and when I try to optimize the largest table (3.5GB) with phpMyAdmin, I get an e-mail message "Drive Critical: /dev/sda6 (/tmp) is 100% full". The /tmp partition is 1.1GB.

phpMyAdmin also never seems to complete. On my old server the table would optimize in about 20 minutes but when I tried it yesterday it went for about an hour before I finally killed the process and then the table was permanently "in use" and I had to restore it from a back up. Today it looks like it is going to be the same result because it has been running for almost 2 hours now.

Am I going to have to pay for an OS reload and have them partition /tmp to be at least the size of my database?

Vatoloco

Nov 20 2007, 09:50 PM

I found a fix:

http://forums.cpanel.net/showpost.php?p=29...amp;postcount=3

QUOTE (dafut)

have mysql write to a different temporary directory, which I created by adding:
tmpdir=/home/mysql

in my.cnf; creating the mysql directory in /home/ and giving it mysql.mysql owner.group ownership; then restarting mysql.

Don't know if that's your issue, but the similarity appears to be there.

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.