MySQL Forums
Forum List  »  MyISAM

Re: MyISAM index corruption
Posted by: Ingo Strüwing
Date: August 05, 2005 01:13AM

The index corruptions due to heavy concurrency is a known bug. But nobody was able to provide a repeatable test case yet. Since we are not yet able to repeat the problem at MySQL AB, we do not know the location of the bug and thus can't fix it yet.

It has been reported that building without linuxthreads helps. This will not cure the MySQL bug, but changes the timing so that the bug does not show up that often.

If switching to InnoDB is an option for you, go ahead. You won't have any MyISAM index corruptions any more ;). I don't know about performance implications though. Nobody, who tried this change, ever reported if he was pleased with it.

Options: ReplyQuote


Subject
Views
Written By
Posted
9350
August 04, 2005 08:19AM
Re: MyISAM index corruption
3139
August 05, 2005 01:13AM
2924
August 05, 2005 05:22AM
2736
August 08, 2005 04:34AM
2750
August 29, 2005 12:56PM
2813
August 30, 2005 02:24AM
2843
August 30, 2005 03:40AM
2608
March 27, 2006 12:32PM
2476
March 28, 2006 02:42AM
2523
March 28, 2006 05:18PM
2642
March 29, 2006 03:35AM
2666
June 04, 2007 11:51AM
2766
July 15, 2007 04:10PM


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.