MySQL Variables default_tmp_storage_engine 数据库 参数变量解释及正确配置使用
本站中文解释
default_tmp_storage_engine 参数用于设置Mysql请求临时表和内存表的默认存储引擎, 可以设置为MyISAM, Memory和InnoDB三种类型的引擎, 其中，MyISAM是最常用的, 可以用于存储大量的非关系数据.
设置default_tmp_storage_engine的方法如下：
1. 用MySQL命令行登录（如”mysql -u root -p”）;
2. 使用”set”命令设置参数, 即”SET GLOBAL default_tmp_storage_engine = ‘MyISAM'”；
3. 使用”show variables like ‘default_tmp_storage_engine'”命令检查变量值是否被设置成功。
官方英文解释
default_tmp_storage_engine
| Command-Line Format | --default-tmp-storage-engine=name |
|---|---|
| System Variable | default_tmp_storage_engine |
| Scope | Global, Session |
| Dynamic | Yes |
| Type | Enumeration |
| Default Value | InnoDB |
The default storage engine for TEMPORARY
tables (created with
CREATE TEMPORARY). To set the storage engine for permanent
TABLE
tables, set the
default_storage_engine system
variable. Also see the discussion of that variable regarding
possible values.
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.
