Today I had a problem with a server where mysql would not start anymore. When starting mysql I got an error message saying:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
So I had a look in my mysql log file (located at /var/log/mysqld.log) and noticed there was no more space on the server.
I needed to know which files were causing this problem and there is a nice command to do this: