InnoDB System Variables --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. 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. For related information, see Section 15.17.2, “Enabling InnoDB Monitors” . Disable the  InnoDB  storage engine. See the description of  --innodb . 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 • daemon_memcached_enable_binlog • --skip-innodb • --innodb-status-file Command-Line Format --innodb-status-file[={OFF|ON}] Type Boolean Default Value OFF Command-Line Format --daemon-memcached-enable- binlog[={OFF|ON}] System Variable daemon_memcached_enable_binlog Scope Global Dynamic No SET_VAR  Hint Applies No Type Boolean Default Value OFF 3213 InnoDB System Variables