At 08:28 AM 5/20/2007, Vitaliy Okulov wrote:
Çäðàâñòâóéòå, mysql.
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.
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
