MySQL Forums :: MyISAM :: Often corrupt table indexes


Advanced Search

Re: Often corrupt table indexes
Posted by: Ingo Strüwing ()
Date: June 13, 2005 02:41AM

There have been several complaints about index corruptions. However, I always thought that it was bound to Windows. But now it seems to be a general problem.

Unfortunately, I see no chance to fix this bug without an (at least somewhat) repeatable test case. Noone ever provided something like that. And I never saw index corruptions on our internal systems (except on test systems during fixing of special crashing bugs).

Instead of myisamchk, you could try the SQL command REPAIR TABLE. If this works, you don't need to care for shutdown or explicit LOCK TABLE.

Using InnoDB instead of MyISAM could help. You won't get MyISAM index corruptions any more ;) However there might be other problems. Anyway, you should give it a try.

Options: ReplyQuote


Subject Views Written By Posted
Often corrupt table indexes 7266 Daniel Draes 06/11/2005 01:54PM
Re: Often corrupt table indexes 2728 Ingo Strüwing 06/13/2005 02:41AM
Re: Often corrupt table indexes 2720 oliver 07/20/2005 01:20AM
Re: Often corrupt table indexes 2439 Ingo Strüwing 07/20/2005 05:25AM
Re: Often corrupt table indexes 2304 oliver 07/20/2005 07:40AM
Re: Often corrupt table indexes 2190 Ingo Strüwing 07/20/2005 09:03AM
Re: Often corrupt table indexes 2175 oliver 07/20/2005 12:13PM
Re: Often corrupt table indexes 2070 Ingo Strüwing 07/21/2005 04:16AM
Re: Often corrupt table indexes 2119 oliver 07/22/2005 03:05PM
Re: Often corrupt table indexes 2098 Ingo Strüwing 07/25/2005 02:26AM
Re: Often corrupt table indexes 2099 Mark Lastdrager 08/01/2005 02:26AM
Re: Often corrupt table indexes 2066 Ingo Strüwing 08/02/2005 03:32AM
Re: Often corrupt table indexes 2126 Mark Lastdrager 08/02/2005 09:00AM
Re: Often corrupt table indexes 2361 kaz mccoy 08/16/2005 12:04PM


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.