Comment 4 for bug 588849

Revision history for this message
mgrennan (mark-grennan) wrote : Re: [Bug 588849] Re: Innodb doesn't load if you change innodb_log_file_size

I agree. Thanks

Mark Grennan
<email address hidden>
+ 1 405 343-9332
aol: grennancom
twitter: mgrennan
http://www.mysqlfanboy.com

----- Original Message -----
From: "Kristian Nielsen" <email address hidden>
To: <email address hidden>
Sent: Tuesday, June 8, 2010 2:06:29 AM GMT -06:00 US/Canada Central
Subject: [Bug 588849] Re: Innodb doesn't load if you change innodb_log_file_size

See also MySQL Bug#19027:

http://bugs.mysql.com/bug.php?id=19027

This is essentially the same bug I think. The fix for Bug#19027 is to
implement an option --enable-plugin_innodb=FORCE; this will cause server to
fail to start if InnoDB/XtraDB does not initialise properly. (This fix is
also in MariaDB).

Apparently the default is --enable-plugin_innodb=ON, which allows the server
to start with XtraDB disabled.

So solution to the reporters original problem is to add
enable-plugin_innodb=FORCE in my.cnf.

I am changing this to two feature requests:

1. Make the default be --enable-plugin_innodb=FORCE for MariaDB.

2. Make XtraDB able to automatically change its log files when the
configuration is changed and the server is restarted, so the user does not
have to do that manually.

** Bug watch added: MySQL Bug System #19027
http://bugs.mysql.com/bug.php?id=19027

--
Innodb doesn't load if you change innodb_log_file_size
https://bugs.launchpad.net/bugs/588849
You received this bug notification because you are a direct subscriber
of the bug.

Status in Maria: Confirmed
Status in Percona XtraDB Storage Engine for MySQL: New

Bug description:
InnoDB fails to load when I set innodb_log_file_size = 10M in my.cnf.

I don't find any errors in the logs. For a time I thought InnoDB was not included in distribution 5.1.44b-MariaDB-mariadb78-log.
After I removed this like from my.cnf it show in the show engine command and my databases returned.

I have learned setting it to the default 'innodb_log_file_size = 5242880' works fine.

To unsubscribe from this bug, go to:
https://bugs.launchpad.net/maria/+bug/588849/+subscribe