Mysql临时表特性_MySQL8.0新特性-临时表的改善

Internal Temporary Table Storage Engine

内部临时表可以保存在内存中，由可试探的或内存存储引擎处理，或者由InnoDB存储引擎存储在磁盘上。

processed by the

TempTable

or

MEMORY

storage engine,

Storage Engine for In-Memory Internal Temporary Tables

The

internal_tmp_mem_storage_engine session variable defines the storage engine for in-memory internal temporary tables. Permitted values are

TempTable (the default) and

MEMORY.

The

TempTable storage engine provides efficient storage for

VARCHAR and

VARBINARY columns. Storage of other binary large object types is supported as of MySQL 8.0.13. The

temptable_max_ram variable defines the maximum amount of RAM that can be occupied by the

TempTable storage engine before it starts allocating space from disk in the form memory-mapped temporary files or

InnoDB on-disk internal temporary table