MySQL Temp Tables

Configuration

tmp-table-size

The maximum size (in bytes) of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables. (1)

Default: 16777216 (16MB)

max-tmp-tables

Default: 32

encrypt-tmp-files

Default: OFF

Bibliography & References