MySQL Forums
Forum List  »  Performance

Re: repair table on 15m records
Posted by: Peter Zaitsev
Date: February 04, 2005 11:58AM

I guess you're speaking about MyISAM table ? By default MyISAM table is repared by single thread so load average should not go above 2 or so (if this is the only command being run). So I guess something else leads to such effect. Might be accesses to other
tables getting starved because of high IO load.

15mill rows is not that much - 2 days is way to long for it. Speaking about improving repair performance - make sure "Repair by Sort" is done not "Repair by Keycache"

Options: ReplyQuote

Written By
February 02, 2005 03:15PM
February 03, 2005 03:59AM
February 03, 2005 11:43AM
Re: repair table on 15m records
February 04, 2005 11:58AM

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.