理 - Li3 - Reason, Logic, Arrange

修理 - Xiu1 Li3 - Repair

The other day my website crashed randomly! I was getting an error message from MySQL: “Can’t open file <SOME_TABLE>.MYD (errno: 145)”. A few minutes of Googling revealed that this sometimes happens, and to fix it all I had to do was say “REPAIR TABLE <SOME_TABLE>”. It worked! But strange.

I checked the logs, but nothing suspicious was going on. It apparently just broke. I wonder if it’s some kind of deadlock? Cause actually two tables were in that same state, and MySQLAdmin reported them both “in use”.