Linux Today: Linux News On Internet Time.

Speed up MySQL backup/dump, restore process for large database

Apr 20, 2011, 08:04 (0 Talkback[s])

[ Thanks to shantanu for this link. ]

"Though this does trick for me but there are other helpful suggestions also which you can try/check to speed up your backup/restore process, few are as follows:

"Increase value of key_buffer_size variable in my.cnf to 20-25% of available RAM as mentioned above. Be aware that, if you make the value too large like setting more than 50% of total RAM, your machine may start to page and become extremely slow. This is because MySQL relies on the operating system to perform file system caching for data reads, so you must leave some room for the file system cache. Anyhow, remember that on 32 bit system, the maximum value key_buffer_size can take is 4gb only and setting any greater might crash your MySQL server."

Complete Story

Related Stories: