Been dealing with a server issue lately, or possibly datacenter failing/unstable PDU, which has been causing spontaneous reboots. Has happened a few times so far and I expect to have the source issue corrected very soon.
After the spontaneous reboots, usually the db ends up with '# clients are using or haven't closed the table properly' type issues along with a seemingly unimportant table having crashed (usually humanverify table).
Today, however, the users table reported crashed/corrupt:
That was the partial result of the following command: "mysqlcheck -c forums"
After running: "mysqlcheck -r forums" to repair, all seems good:
My question(s):
Is the user table now fine / repaired without any corruption in the text of the database records?
Being that the user table is relatively important, my concerns are that maybe now there could be random user records in that table with messed up information which is not detected as an error by mysqlcheck. Is that possible?
What's the likelihood that this crash/corruption caused further undetected issues?
I'm probably just being paranoid about it, but maybe somebody here who knows more about these things can help me better understand all of this.
Any input / advice is much appreciated.
After the spontaneous reboots, usually the db ends up with '# clients are using or haven't closed the table properly' type issues along with a seemingly unimportant table having crashed (usually humanverify table).
Today, however, the users table reported crashed/corrupt:
Code:
forums.user warning : Table is marked as crashed warning : 2 clients are using or haven't closed the table properly error : Checksum for key: 6 doesn't match checksum for records error : Corrupt
After running: "mysqlcheck -r forums" to repair, all seems good:
Code:
forums.user OK
Is the user table now fine / repaired without any corruption in the text of the database records?
Being that the user table is relatively important, my concerns are that maybe now there could be random user records in that table with messed up information which is not detected as an error by mysqlcheck. Is that possible?
What's the likelihood that this crash/corruption caused further undetected issues?
I'm probably just being paranoid about it, but maybe somebody here who knows more about these things can help me better understand all of this.
Any input / advice is much appreciated.
Comment