MySQL: How to Reduce the Number of Internal Temporary Tables Created On Disk?, Created_tmp_disk_tables, Created_tmp_tables, max_heap_table_size, tmp_table_size, temptable_max_ram
(Doc ID 1374804.1)
Last updated on SEPTEMBER 04, 2023
MySQL Server - Version 4.0 and later
Information in this document applies to any platform.
Learn about the status variables and server options related to internal temporary tables and how to avoid creating internal temporary tables on disk.
The status variables include:
The server options include:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.