Bug #44470 innodb_file_io_threads precludes mysql from starting

Submitted: 24 Apr 2009 19:22 Modified: 25 Jun 2009 1:56
Reporter: Mark Konetchy Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: General Severity:S2 (Serious)
Version:5.4.0-beta OS:Linux (Fedora Core release 4, Mac OS X)
Assigned to: Alexey Botchkov CPU Architecture:Any

[24 Apr 2009 19:22] Mark Konetchy
Description:
Specifying innodb_file_io_threads in my.cnf (as is the default in my-innodb-heavy.cnf) makes mysql error out on installation.

How to repeat:
# mysql -V

mysql  Ver 14.14 Distrib 5.4.0-beta, for unknown-linux-gnu (x86_64) using readline 5.1

# cat /etc/redhat-release 
Fedora Core release 4 (Stentz)
 ----------------------------------------------------

+ when its enabled, startup fails

# awk /innodb_file_io_threads/ /etc/my.cnf

innodb_file_io_threads = 4

# /usr/local/mysql/bin/mysqld_safe &
[1] 26474
[root@dev267.snc1 ~]# 090424 12:17:22 mysqld_safe Logging to '/var/lib/mysql/mysql.err'.
090424 12:17:22 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
090424 12:17:24 mysqld_safe mysqld from pid file /usr/local/mysql/data/dev267.snc1.facebook.com.pid ended

[1]+  Done                    /usr/local/mysql/bin/mysqld_safe

here is the failure in the error log (full log is pasted below):

090424 12:17:23 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'innodb_file_io_threads=4'
090424 12:17:23 [ERROR] Aborting

090424 12:17:23  InnoDB: Starting shutdown..

-------------------------------------------------------

when its commented out, its fine.....

# awk /innodb_file_io_threads/ /etc/my.cnf

innodb_file_io_threads = 4

# /usr/local/mysql/bin/mysqld_safe &
[1] 26783
[root@dev267.snc1 ~]# 090424 12:17:42 mysqld_safe Logging to '/var/lib/mysql/mysql.err'.
090424 12:17:42 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

---------------------------------------------

the error log (note the times):

090424 12:16:50 mysqld_safe mysqld from pid file /usr/local/mysql/data/dev267.snc1.facebook.com.pid ended
090424 12:17:22 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
090424 12:17:22 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead.
tcmalloc: large alloc 1610633216 bytes == 0x2aaaab261000 @
InnoDB: The InnoDB memory heap has been disabled.
InnoDB: Mutex and rw_lock use atomics.
InnoDB: ios_per_array 256 read threads 8 write threads 8
InnoDB master thread running with io_capacity 200
090424 12:17:23  InnoDB: Started; log sequence number 0 46409
090424 12:17:23 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'innodb_file_io_threads=4'
090424 12:17:23 [ERROR] Aborting

090424 12:17:23  InnoDB: Starting shutdown...
090424 12:17:24  InnoDB: Shutdown completed; log sequence number 0 46409
090424 12:17:24 [Warning] Forcing shutdown of 1 plugins
090424 12:17:24 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

090424 12:17:24 mysqld_safe mysqld from pid file /usr/local/mysql/data/dev267.snc1.facebook.com.pid ended
090424 12:17:42 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
090424 12:17:42 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead.
tcmalloc: large alloc 1610633216 bytes == 0x2aaaab261000 @
InnoDB: The InnoDB memory heap has been disabled.
InnoDB: Mutex and rw_lock use atomics.
InnoDB: ios_per_array 256 read threads 8 write threads 8
InnoDB master thread running with io_capacity 200
090424 12:17:43  InnoDB: Started; log sequence number 0 46409
090424 12:17:43 [Note] Event Scheduler: Loaded 0 events
090424 12:17:43 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.4.0-beta-log'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Server (GPL)

Suggested fix:
make non windows OS's ignore this one
[25 Apr 2009 9:43] Valeriy Kravchuk
Thank you for the problem report. Verified just as described.
[18 Jun 2009 4:55] Gael Martinez
This issue is also present in the solaris 10 sparc version into my-innodb-heavy-4G.cnf. The OS listed here is only Linux...
[22 Jun 2009 13:58] Alexey Botchkov
pushed in 5.1-performance tree
[22 Jun 2009 16:08] Trudy Pelzer
Pushed to 5.4.2.
[25 Jun 2009 1:56] Paul DuBois
Noted in 5.4.2 changelog.

The my-innodb-heavy-4G.cnf sample option file contained a setting for
the no longer existing innodb_file_io_threads system variable. This
has been replaced with settings for the innodb_write_io_threads and
innodb_read_io_threads system variables with which
innodb_file_io_threads has been replaced.
[16 Sep 2009 6:45] Bugs System
Pushed into 5.4.4-alpha (revid:alik@sun.com-20090916063112-8hjmu6wkxfx5qxf4) (version source revid:guilhem@mysql.com-20090708213845-36vjraclcpz7mwlq) (merge vers: 5.4.4-alpha) (pib:11)

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.058 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.