At 08:28 AM 5/20/2007, Vitaliy Okulov wrote:
>How i can speedup restore of mysql DB from file created by mysqldump?
MySQL is quite fast at reloading data, but if you don't have enough memory
or if key_buffer_size is not set high enough, then it can take days to
re-index the data. You need to stuff as much RAM as possible in your
machine and set key_buffer_size to at least 30% of your machine RAM. I've
had indexed take 2+ days to rebuild and adding more RAM and tweaking
key_buffer_size allowed the same keys to be rebuilt in under an hour.