Re: Fwd: innodb_log_files_in_group

2006-12-28 Thread David Sparks
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. Thanks, I think I recall reading that text before. It doesn't really answ

Fwd: innodb_log_files_in_group

2006-12-27 Thread Juan Eduardo Moreno
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

innodb_log_files_in_group

2006-12-27 Thread David Sparks
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]

Re: /etc/my.cnf does not contain innodb_log_files_in_group.

2002-12-20 Thread Heikki Tuuri
Hi! For the record, I exchanged email with Kip, and it turned out he had forgotten to add the keyword 'set-variable' to the my.cnf line. It should be set-variable=innodb_log_files_in_group=... Note that the default is 2 if you have not specified this previously in your my.cnf. I rea

/etc/my.cnf does not contain innodb_log_files_in_group.

2002-12-19 Thread hostmaster
>Description: After ugrading from MySQL-Max-3.23.53 to 3.23.54, mysqld failed to start. Error message was:/usr/sbin/mysqld-max: unrecognized option `--innodb_log_files_in_group=3'. This option required for Innodb Hot backup! >How-To-Repeat: Just up