[Sussex] Fedora Core 5 - lossing disk space

[Brendan Whelan]

Thanks to all those who responded  - I had looked in the log directory but
not specifically in the http section. Once I have found that the logs were
full it was fairly easy to get everything back in action but I have to track
down the cause. Just in case it happens again, below are my notes.



Brendan



Problem - Full disk and database damaged



Tracking down where disk space is being consumed and getting MySQL back in
action



Connect to the server, in my case with "putty"



Stopped the database and apache:

service mysqld stop

service httpd stop



Find which device is full



df -h



In my case is was the main volume so I simply set myself to the highest
level:



cd ..



sudo du -xk | sort -rn | less



It revealed that the /var/log/httpd directory contained lots of messages.



Listing the directory showed that the error_logs were huge.



Cleared the logs (I will investigate the cause when the system is quiet.)



Restarted the MySQL

service mysqld start



Check the database tables:



cd /var/lib/mysql/my_project..

myisamchk *.MKI



Two tables listed as damaged, repaired as follows:



myisamchk -r -q my_table_name...



Repeated the above for other projects.



Restarted apache:



service mysqld start