You examine the output of SHOW GLOBAL STATUS and notice that the value of
Created_tmp_disk_tables is consistently increasing.
Which two variables would likely fix this issue?
A.
Table_open_cache
B.
Table_open_cache_instancs
C.
Table_definition_cache
D.
Tmp_table_size
E.
Max_heap_table_size
F.
Max_tmp_tables
Explanation:
D,E
http://dev.mysql.com/doc/refman/5.6/en/server-status-variables.html
D,E checked
DE
D, E