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.
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.