I have a linode 4096 that is a MySQL server for an application on another linode... For some reason, I cannot get the temporary tables on disk under 35% when running mysqltuner.pl...

Am I missing something? Here is my current my.cnf...BTW, I had my tmp_table_size and Max_heap set to 1G each and I still had the same issue...


key_buffer = 24M
max_allowed_packet = 1M
thread_stack = 64K
thread_cache_size = 16
tmp_table_size = 120M
max_heap_table_size = 120M
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover = BACKUP
max_connections = 60
table_cache = 800
join_buffer_size =2M
sort_buffer =4M
net_buffer_length = 2K
#thread_concurrency = 10
innodb_buffer_pool_size = 2000M
# * Query Cache Configuration
#
query_cache_limit = 6M
query_cache_size = 72M

Sometimes the temp tables have to be written to disk. See http://dev.mysql.com/doc/refman/5.1/en/ ... ables.html for the reasons why.