Re: How to get high performance on repair huge MYISAM tables?
Posted by:
Rick James
Date: December 25, 2008 01:33AM
myisamchk does not use those settings for itself; check the docs for how to specify settings for it.
key_buffer = 1/2 of RAM -- that is excessive (usually).
Meanwhile, the key_buffer size for myisamchk (whatever it is set to) may be much too small when a table needs its index to be rebuilt. Check the settings for max_... -- some deal with REPAIR, some don't.
RAID-0: Good. SATA: not sure.
If you had another slave, you could better afford this one being offline for a day.
How fast can you do "wc" on a 100GB file? That gives you a clue of the raw read speed of the disks. How fast can you "cp" that file? REPAIRing a table cannot run any faster than that.
Do you have 150+GB on a 240GB system? That's pushing it! You need room for a copy of the data and index during the REPAIR.
I don't know ubantu's tuning thingies.
SCSI RAID with BBWC would probably run somewhat faster. (But more $)
Subject
Views
Written By
Posted
4501
December 24, 2008 02:43AM
Re: How to get high performance on repair huge MYISAM tables?
4322
December 25, 2008 01:33AM
3188
December 26, 2008 12:28AM
2643
February 24, 2009 12:09AM
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.