Bug #56946 innodb_io_capacity produces startup error

• Submitted: 22 Sep 2010 18:11
• Modified: 25 Sep 2010 8:37
• Reporter: randy melder
• Status: Not a Bug
• Category: MySQL Server: InnoDB Plugin storage engine
• Severity: S3 (Non-critical)
• Version: 5.1.50
• OS: Linux
• CPU Architecture: Any

[22 Sep 2010 18:11] randy melder

Description:
Downloaded and installed MySQL-server-community-5.1.50-1.rhel5.x86_64.rpm 

Adding the following configuration to /etc/my.cnf:
innodb_io_capacity = 600

Prevents MySQL from starting
e.g.

100922 10:49:59 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_io_capacity=600'
100922 10:49:59 [ERROR] Aborting
100922 10:49:59  InnoDB: Starting shutdown...
100922 10:50:05  InnoDB: Shutdown completed; log sequence number 0 48552
100922 10:50:05 [Note] /usr/sbin/mysqld: Shutdown complete

100922 10:50:05 mysqld_safe mysqld from pid file /opt/vmix/mysql/sd-db-common-01.vmix.com.pid ended

How to repeat:
Add "innodb_io_capacity = 600" to your my.cnf and restart mysqld.

Suggested fix:
Either ignore this variable and comment in the error log why it has been ignored or fix the build to utilize innodb_io_capacity.

[23 Sep 2010 6:25] Valeriy Kravchuk

Please, send your entire /etc/my.cnf file content.

As innodb_io_capacity is InnoDB Plugin-only variable (see http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_io_capacity) I want to check if you start plugin instead of built-in InnoDB.

[23 Sep 2010 16:02] randy melder

I mistakenly assumed that the plugin was loaded by default. After enabling the InnoDB plugin this variable was applied and mysqld started with no problem. Thanks for enduring my ignorance. :-)

[25 Sep 2010 8:37] Sveta Smirnova

Thank you for the report.

Verified as described.

[25 Sep 2010 9:04] Sveta Smirnova

I am sorry: I meant "Not a Bug" in previous comment.