Server Load increased suddenly and some queries were taking too much time now while working fine earlier (Issues: Myisam Table Currupt)
Problem: Server Load increased suddenly and some queries were taking too much time now while working fine earlier.
Steps to track the reason:
Step 1: As it was suddenly while earlier server was working fine, so I checked error logs and error messages but could not get any clue as there was every thing fine and server will not reported any error.
Step 2: When I was monitoring running queries on server and also slow logs then get a clue. Those 2 queries were taking more than expected time, were using a common table, on which I did bulk update in a field.
My Assumption: As queries realted with a specific table were taking time and that table engine was myisam, so probably this issue can be due to table currupt but I was not getting any clue in any logs.
Solution: As server load was continue increasing, so I decided to repair that table.
mysql> repair table mytable;
Conclusion: After repairing the table every thing was fine as now server load was going to normal and these queries were also running smoothly.
Note: It’s (table curruption issue) possibility quite high in myisam tables.