Bug #786 innodb_logfile settings have no effect

• Submitted: 3 Jul 2003 12:23
• Modified: 3 Jul 2003 16:52
• Reporter: Daniel Sorrentino
• Status: Not a Bug
• Category: MySQL Server: InnoDB storage engine
• Severity: S1 (Critical)
• Version: 4.0.0-alpha
• OS: Solaris (Solaris)
• CPU Architecture: Any

[3 Jul 2003 12:23] Daniel Sorrentino

Description:
Changing logfile number and size has no effect in my.cnf for mysqld.

I always get 2 log files at 5M even with these settings:

set-variable = innodb_log_files_in_group=1
set-variable = innodb_log_file_size=1M

I also tried doing --innodb_log_files_in_group=1 and innodb_log_file_size=1M on 
the mysqld command line and found that these are illegal options.

I want to setup mysql for use by my class, but these file sizes would be frowned
on by the administrators.

Can you help?

How to repeat:
N/A

[3 Jul 2003 16:52] Heikki Tuuri

Hi!

innodb_log_files_in_group must always be >= 2.

For the log file size 1M is the minimum, 5M the default.

You have probably placed your my.cnf to a wrong directory, if mysqld is not reading it. Please look at http://www.innodb.com/ibman.html#InnoDB_start for instructions on where to put my.cnf.

I also recommend upgrading to 4.0.13. Your MySQL version is very old and lots of bugs have been fixed since.

Regards,

Heikki