Re: Mysqldump and innodb

[Aftab Khan]

innodb_buffer_pool_size=2G # On dedicated systems it should be 50% to 80% of the machine physical memory size

innodb_log_file_size= 256M # The larger the value, the less checkpoint flush activity is needed in the buffer pool, saving disk I/O


innodb_flush_log_at_trx_commit=0 # You can achieve better performance by setting the value different from 1, when top performance is needed rather than concern for data integrity or possible failures


innodb_doublewrite= 0 # This variable can be turned off when top performance is needed rather than concern for data integrity or possible failures

Remember to reboot mysql after making above changes

If you are able to shut down your MySQL server, you can make a binary backup that consists of all files used by InnoDB to manage its tables. Use the following procedure:

1.

Shut down your MySQL server and make sure that it shuts down without errors.
2.

Copy all your data files (ibdata files and .ibd files) into a safe place.
3.

Copy all your ib_logfile files to a safe place.
4.

Copy your my.cnf configuration file or files to a safe place.
5.

Copy all the .frm files for your InnoDB tables to a safe place.



Edited 1 time(s). Last edit at 06/08/2009 05:21AM by Aftab Khan.