MySQL Forums
Forum List  »  MyISAM

Simulating corrupt index on MyISAM table
Posted by: Jason Riffel
Date: January 19, 2010 07:53AM

My question, is there a way for me to manually mark the table as corrupted in our development environment so we can develop and QA the auto repair feature?

Additionally, if anyone has any advice or ideas as to why this table is becoming marked corrupt so frequently that would be very much appreciated as well.

Background:

Our product uses INNODB primarily except one table which is MyISAM and full text indexed for searching metadata. This MyISAM table ends up with corrupt indexes without crashes or disk errors on a very frequent basis (across multiple properties and servers). It is always corrected by a simple table repair and we are considering building this into our product due to the number of support requests we get.

Thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
Simulating corrupt index on MyISAM table
5146
January 19, 2010 07:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.