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
10135
August 04, 2005 08:19AM
Re: MyISAM index corruption
3419
August 05, 2005 01:13AM
3157
August 05, 2005 05:22AM
2996
August 08, 2005 04:34AM
2990
August 29, 2005 12:56PM
3060
August 30, 2005 02:24AM
3104
August 30, 2005 03:40AM
2877
March 27, 2006 12:32PM
2724
March 28, 2006 02:42AM
2791
March 28, 2006 05:18PM
2978
March 29, 2006 03:35AM
2912
June 04, 2007 11:51AM
3069
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.