Linux Today: Linux News On Internet Time.
Search Linux Today
Linux News Sections:  Developer -  High Performance -  Infrastructure -  IT Management -  Security -  Storage -
Linux Today Navigation
LT Home
Contribute
Contribute
Link to Us
Linux Jobs


Top White Papers

More on LinuxToday


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: