MySQL Variables default_storage_engine 数据库 参数变量解释及正确配置使用
本站中文解释
MySQL的default_storage_engine变量用于定义存储在MySQL中的表的数据引擎，以及表中建立的索引和外键。默认情况下，MySQL会使用MyISAM，但是也有几个其它的可选的数据引擎，例如InnoDB、Memory、CSV等等。要设置default_storage_engine参数，可以在my.cnf文件中添加以下内容：
default_storage_engine = InnoDB
官方英文解释
default_storage_engine
| Command-Line Format | --default-storage-engine=name |
|---|---|
| System Variable | default_storage_engine |
| Scope | Global, Session |
| Dynamic | Yes |
| Type | Enumeration |
| Default Value | InnoDB |
The default storage engine for tables. See
Chapter 15, Alternative Storage Engines. This variable sets the
storage engine for permanent tables only. To set the storage
engine for TEMPORARY tables, set the
default_tmp_storage_engine
system variable.
To see which storage engines are available and enabled, use
the SHOW ENGINES statement or
query the INFORMATION_SCHEMA
ENGINES table.
If you disable the default storage engine at server startup,
you must set the default engine for both permanent and
TEMPORARY tables to a different engine or
the server cannot start.
