FYI ---------- Forwarded message ---------- From: Juan Eduardo Moreno <[EMAIL PROTECTED]> Date: Dec 27, 2006 9:30 PM Subject: Fwd: innodb_log_files_in_group To: [EMAIL PROTECTED]
Dave, The default (and recommended) is 2. The log files, save the trasactions into file in circular order. This files are like a redolog files in oracle. This log file are useful when you recover your database after some crash for example or when you use a replication mysql. innodb_buffer_pool_size you don`t have any restrictions ( normally 80% of phisical mem). Now, for the innodb_log_file_size ( 25% of buffer_pool_size) , the combined size of the InnoDB log files must not exceed 4 GB. If you have 2 log files, you can make each at most 2000 MB in size. When you startup your MySQL using innodb, in your my.cnf you can set the variable innodb_log_files_in_group. For example, if your set innodb_log_files_in_group=2 ( ib_log_file001, ib_log_file002 are created) the total size must not exceed 4G. Regards, Juan On 12/27/06, David Sparks < [EMAIL PROTECTED]> wrote:
Is there any benefit/reason to set innodb_log_files_in_group to something other than 2? Thanks, ds -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
