java.sql.SQLException: Table '<table name>' is marked as crashed and last automatic(?) repair failed
What does it mean, and how do you fix it?
The MySQL database uses MyISAM as a default storage engine, and the MyISAM table is easily corrupted.
But take heart, you can use the MyISAMCHK command to resolve crashed tables. The article, How to Run a myisamchk to Resolve Crashed mysql Tables, provides detailed instructions on using the MyISAMCHK commands for Windows and Linux to resolve crashed MySQL tables in your Storage Manager powered by Profiler product.
The MySAMCHK provides other useful commands such as:
For more information on these and other MYSAMCHK options, see How to Repair Corrupted MySQL Tables Using MyISAMCHK
A common cause for crashed tables in MySql is antivirus, intrusion detection, or backup software. This can happen when these programs lock files in the MySQL database while Storage Manager is trying to use the files.
To prevent conflicts, add exceptions to these tools so they do not access the <STM Server Install Directory>\mysql folder and sub folders. Storage performance monitoring simplified!
I'd like to hear about your experience with MySQL table crashes, and how you fixed them with your storage performance monitoring software.