My mysql server suddenly started showing my disk space usage as almost full.
[root@abc /]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 550G 508G 14G 98% /
tmpfs 32G 0 32G 0% /dev/shm
/dev/sda1 2.0G 173M 1.8G 9% /tmp
But when I issued a disk usage check on / , it returned the usage to be very little.
[root@abc /]# du -sch
I was sure there is something wrong. Hence, I checked for deleted files. You can use either of the following commands.
[root@abc /]# lsof +L1
mysqld 23193 mysql 5u REG 8,1 184 0 13 /tmp/ibrUf6yr (deleted)
mysqld 23193 mysql 6u REG 8,1 0 ...