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
Triage: Triaged: D3 (Medium)

[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)