Bug #786 innodb_logfile settings have no effect
Submitted: 3 Jul 2003 12:23 Modified: 3 Jul 2003 16:52
Reporter: Daniel Sorrentino Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S1 (Critical)
Version:4.0.0-alpha OS:Solaris (Solaris)
Assigned to: 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