content_image/788803.jpg content_image/788804.jpg
--default-tmp-storage-engine  to set the default to some other engine for both permanent and TEMPORARY  tables. 

The InnoDB  storage engine can no longer be disabled, and the --innodb=OFF  and --skip-innodb options are deprecated and have no effect. Their use results in a warning. Expect these options to be removed in a future MySQL release. 

• --innodb-status-file 

<img src='content_image/788803.jpg'>

The --innodb-status-file  startup option controls whether InnoDB  creates a file named innodb_status. pid  in the data directory and writes SHOW ENGINE INNODB STATUS  output to it every 15 seconds, approximately. 

The innodb_status. pid  file is not created by default. To create it, start mysqld  with the --innodb- status-file  option. InnoDB  removes the file when the server is shut down normally. If an abnormal shutdown occurs, the status file may have to be removed manually. 

The --innodb-status-file  option is intended for temporary use, as SHOW ENGINE INNODB STATUS  output generation can affect performance, and the innodb_status. pid  file can become quite large over time. 

## InnoDB System Variables 

For related information, see Section 15.17.2, “Enabling InnoDB Monitors” . 

• --skip-innodb 

Disable the InnoDB  storage engine. See the description of --innodb . 

• daemon_memcached_enable_binlog 

<img src='content_image/788804.jpg'>

Enable this option on the source server to use the InnoDB memcached  plugin ( daemon_memcached ) with the MySQL binary log. This option can only be set at server startup. You must also enable the MySQL binary log on the source server using the --log-bin  option. 

For more information, see Section 15.20.7, “The InnoDB memcached Plugin and Replication” . 

• daemon_memcached_engine_lib_name 

