Re: MyISAM index corruption
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.
Subject
Views
Written By
Posted
9976
August 04, 2005 08:19AM
Re: MyISAM index corruption
3347
August 05, 2005 01:13AM
3088
August 05, 2005 05:22AM
2930
August 08, 2005 04:34AM
2925
August 29, 2005 12:56PM
2995
August 30, 2005 02:24AM
3030
August 30, 2005 03:40AM
2811
March 27, 2006 12:32PM
2653
March 28, 2006 02:42AM
2709
March 28, 2006 05:18PM
2899
March 29, 2006 03:35AM
2845
June 04, 2007 11:51AM
2997
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.