facebook twitter youtube
Replication Query Optimization DB Tuning Server Load and Query Locking Linux Download Interview Questions Basic DB Commands Mysql
by Zafar Malik - no comments
Server Load increased suddenly and some queries were taking too much time now while working fine earlier (Issues: Myisam Table Currupt)

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.

Leave a Reply