MySQL troubleshooting

Just in case you are facing downtime issues on MySQL on CentOS try these. Check if disk is full df -h if disk is full check which folder is occupying lot of space. cd / du -skh * Then go into individual folders to check if files can be deleted. If mysql/ folder looks like culprit, below steps might be useful. If mysqld.log is big, trim it. sudo echo -n > mysqld.log In case there are 1.1GB files with sequence file numbers, e.g. xxx.00001, xxx.00002…

Read More »