i get 2-3 mails from server evry day , i cant be online whole day , when ever i check temp after watching this mail its back to normal 3-4% of 2gb allotted , i am really confused what may be eating so much temp and just disappear ?
my $tmpdsksize = 512000; # Must be larger than 250000
my $tmpdsksize = 2097152; # Must be larger than 250000
umount -l /tmp
umount -l /var/tmp
rm -fv /usr/tmpDSK
/scripts/securetmp
yum install tmpwatch
0 * * * * /usr/sbin/tmpwatch --mtime --all 24 /tmp
Incorrect key file for table '/tmp/#sql_4108_0.MYI'; try to repair it
grep "Incorrect key" /var/lib/mysql/hostname.err
vi /etc/my.cnf
tmpdir=/mysqltmp
mkdir /mysqltmp
chmod 1777 /mysqltmp
/etc/init.d/mysql restart
mysqladmin var | grep tmpdir
# mysqladmin var | grep tmpdir
| slave_load_tmpdir | /mysqltmp
| tmpdir | /mysqltmp
You can use the following steps to move the MySQL /tmp directory location:
1. Edit /etc/my.cnf file to set new tmpdir for MySQL
Place the following line into the file under the [mysqld] section:Code:vi /etc/my.cnf
Save the file with :wqCode:tmpdir=/mysqltmp
2. Create the /mysqltmp directory
3. Restart MySQL and check that the tmpdir is now /mysqltmpCode:mkdir /mysqltmp chmod 1777 /mysqltmp
You should see the following return:Code:/etc/init.d/mysql restart mysqladmin var | grep tmpdir
This presumes / partition itself has sufficient space. I would like to hope / partition would have more space than /tmp was provided on most systems.Code:# mysqladmin var | grep tmpdir | slave_load_tmpdir | /mysqltmp | tmpdir | /mysqltmp
tmpdir=/home/mysqltmp
whereis tmpwatch
yum install tmpwatch
Package tmpwatch-* already installed and latest version