Friday, August 1, 2014

debugging mysql failure

culprit # 1 : disk full

df -h

remove logs

repair databases
mysqlcheck --repair --all-databases -u root -p


individual

use <db>
check table <table>
repair table <table>

remove tmp overflow:

sudo umount overflow


No comments:

Post a Comment