InnoDB Command Options Name Cmd-Line Option File System Var Status Var Var Scope Dynamic innodb_temp_tablespaces_dir Yes Yes Yes Global No innodb_thread_concurrency Yes Yes Yes Global Yes innodb_thread_sleep_delay Yes Yes Yes Global Yes innodb_tmpdir Yes Yes Yes Both Yes Innodb_truncated_status_writes Yes Global No innodb_trx_purge_view_update_only_debug Yes Yes Yes Global Yes innodb_trx_rseg_n_slots_debug Yes Yes Yes Global Yes innodb_undo_directory Yes Yes Yes Global No innodb_undo_log_encrypt Yes Yes Yes Global Yes innodb_undo_log_truncate Yes Yes Yes Global Yes innodb_undo_tablespaces Yes Yes Yes Global Varies Innodb_undo_tablespaces_active Yes Global No Innodb_undo_tablespaces_explicit Yes Global No Innodb_undo_tablespaces_implicit Yes Global No Innodb_undo_tablespaces_total Yes Global No innodb_use_fdatasync Yes Yes Yes Global Yes innodb_use_native_aio Yes Yes Yes Global No innodb_validate_tablespace_paths Yes Yes Yes Global No innodb_version Yes Global No innodb_write_io_threads Yes Yes Yes Global No unique_checks Yes Both Yes Command-Line Format --innodb[=value] Deprecated Yes Type Enumeration Default Value ON Valid Values OFF ON FORCE InnoDB Command Options • --innodb[= value ] Controls loading of the  InnoDB  storage engine, if the server was compiled with  InnoDB  support. This option has a tristate format, with possible values of  OFF ,  ON , or  FORCE . See Section 5.6.1, “Installing and Uninstalling Plugins” . To disable  InnoDB , use  --innodb=OFF  or  --skip-innodb . In this case, because the default storage engine is  InnoDB , the server does not start unless you also use  --default-storage-engine  and 3212