Drive Critical: /dev/loop0 (/var/tmp)

[Divvy]

Can someone teach me how to make this change?

It appears that something was writing to /tmp and filling it up, but it appears now to be clearing out. The df cache is still catching up at this time. It is normal for the df cache to be a bit behind on a linux server. I suspect that mysql may be behind the filling of /tmp. I'd recommend setting the tmpdir directive in your /etc/my.cnf to a larger partition. For example, something like the following:
tmpdir = /home/mysql

You should make sure that the directory is owned mysql:mysql and then restart mysql in order for this change to take effect.

Any tutorial out there?

[Divvy]

please, anyone?

[Lock Down]

tutorial? Edit the file /etc/my.cnf and find the line with tmpdir = .

If it is not there you can add what was suggested /home/mysql
after this line : [mysqld]
then save it. Create the new folder
mkdir /home/mysql
Then change owner:group
chown mysql:mysql /home/mysql

Then restart mysql service.
service mysqld restart

[Divvy]

Thank you Lock Down!
But yesterday I take a look at Daily Process Log and found a user account that was with 35.0 MySQL Processes... I suspended that account and everything returns to normal finally. That user account was using a phpBB forum, now I need to check what was causing that.
But at least I have my server back to normal again! hehe

Btw, I gave you reputation for the trouble that you had writing those instructions