MySQL Forums
Forum List  »  MyISAM

index corruption on windows
Posted by: Kevin
Date: June 08, 2005 12:23PM

We have several installations of MySQL on various windows servers XP/2000/2003 and on each we get what seem to be arbitrary corruption of the index files. So far we have been unable to isolate a single common set of circumstances that is causing the problems. And am looking for some help or a point in the right direction to find the issue. Here are the common facts that I have collected

1. We are running mysql 4.0.14.
2. Our application is very write intensive both inserts and updates, and many hundreds of writes per second.
3. There is also the possibility of many large deletes.
4. It is in Java and uses the MySQL Connector/J.
5. The same code runs fine on Linux and Solaris.

I did notice several changes in the 4.0.X change logs relating to index corruption, but I don't believe the specific cases apply to our situation.

I noticed a few other cries for help similar to this on the mailing lists and some of the forums, but found little follow up from the original poster, so maybe my query will just be thrown in to the ring as well. But I thought it worth a try to get some clues, so can any one offer any insight?

Thank you,
Kevin

Options: ReplyQuote


Subject
Views
Written By
Posted
index corruption on windows
3010
June 08, 2005 12:23PM


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.