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
