MySQL Forums
Forum List  »  MyISAM

Advanced Search
New Topic

Repair seems memory bound
Posted by: Elisa Towbis
Date: June 06, 2010 12:00PM

Hi,

I have a 15 million row table, 2GB of data, that never survives a crash as its always being written to. When I go to repair it, CPU stays low, and Memory doesn't increase.

I'd gladly have both go up to speed up the 20-25 minute repair. I've got the MyIsam Sort Buffer set to 2048 M (via MySQL Administrator). Its a 4GB Windows box with about 2GB regularly allocated.

Is there another way/setting that will allow this action to consume more resources and more importantly complete faster?

Thanks,

Elisa

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Repair seems memory bound
2994
Elisa Towbis
June 06, 2010 12:00PM
Re: Repair seems memory bound
1942
Saurabh Deshpande
June 16, 2010 06:00AM


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.