This MySQL server has been running for 0 days, 1 hours, 59 minutes and 42 seconds.
Query statistics: Since its startup, 246,498 queries have been sent to the server.
I dont understand why my tmp tables on disk would be so high with a 1G tmp_table_size and Max_heap_table_size
I am running CentOS5.3 and 5.0.82 percona b16… I have 12GB of ram and dual 3.04G CPU. Just upgraded to be able to change my temp directive.
Created_tmp_disk_tables 34 k
Created_tmp_files 5
Created_tmp_tables 49 k
tmp_table_size = 1G
max_heap_table_size = 1G
Any ideas?