Created_tmp_disk_tables 10 k within the PHPMyAdmin status screen and it's in red. 10k is an awful lot. Is it my queries or server settings that are allowing temporary tables to get this high? Is there any way to log queries that are creating temporary tables (please say yes)?
This is what you need to know..
If an internal temporary table is created initially as an in-memory table but becomes too large..
MySQL automatically converts it to an on-disk table. The maximum size for in-memory temporary tables is the minimum of the tmp_table_size and max_heap_table_size values.
BTW... When the server creates an internal temporary table (either in memory or on disk), it increments the Created_tmp_tables status variable. If the server creates the table on disk (either initially or by converting an in-memory table) it increments the Created_tmp_disk_tables status variable.
What your seeing is an increment.. so when was the last time you restarted your mysql?? :D
|show 5 more comments|