Hi,

I have problem with my Mysql, when i try to access it, i get this error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

If i try to reload it (/etc/init.d/mysqld restart) i get this:
mysqld failed!

In Log file (/var/log/mysqld.log) i found this error:
Can't start server: can't create PID file: No space left on device

I have found in Google, that the problem depend on the free space of partition. when i excute the df command i get:

Sys. de fich. 1K-blocs Occupé Disponible Capacité Monté sur
/dev/mapper/VolGroup01-LogVol00
297673144 282395936 0 100% /
/dev/sda1 101086 18357 77510 20% /boot
tmpfs 4153560 0 4153560 0% /dev/shm

I know that the "/" is 100%, but when i type du -h --max-depth=1 /
0 /proc
5,7M /bin
147M /lib
120K /dev
8,0K /media
12K /home
1,7G /usr
16K /lost+found
22G /var
8,0K /srv
0 /sys
8,0K /mnt
8,0K /opt
13M /boot
47M /etc
8,0K /selinux
9,9M /root
24G /

Knowing that the Hardisk size is much larger than 24G.

Thanks in advance for your responses.

Please put command output in code tags, not red font tags. Especially for output where horizontal whitespace is significant, the code tags use a monospace font that makes what you're trying to communicate decipherable.

Further, this is not a "can't connect to MySQL through socket" problem. This is a filesystem space problem, as you noted.

It may be useful to see the output from:

Now is good, after i have launched this:

lsof -n |grep -i deleted
df -i

i have rebooted the system, and all is ok now

[root@DialerMRS1 src]# df -h
Sys. de fich. Tail. Occ. Disp. %Occ. Monté sur
/dev/mapper/VolGroup01-LogVol00
284G 24G 246G 9% /
/dev/sda1 99M 18M 76M 20% /boot
tmpfs 4,0G 0 4,0G 0% /dev/shm