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
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
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]
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
>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