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?
Two possibilities for finding and fixing MySQL table crashes
MyISAM storage engine
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.
More MyISAMCHK options
The MySAMCHK provides other useful commands such as:
Identify all corrupted tables
Repair corrupted tables
Perform check and repair together for the entire MySQL database
Allocate additional memory for a large MySQL database
Anti-virus, intrusion detection, or back up software is blocking MySQL
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!
Share your MySQL table crashes
I'd like to hear about your experience with MySQL table crashes, and how you fixed them with your storage performance monitoring software.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community.
More than 150,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.