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 tmptablesize and Max_heap set to 1G each and I still had the same issue…

key_buffer = 24M

maxallowedpacket = 1M

thread_stack = 64K

threadcachesize = 16

tmptablesize = 120M

maxheaptable_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

joinbuffersize =2M

sort_buffer =4M

netbufferlength = 2K

thread_concurrency = 10

innodbbufferpool_size = 2000M

* Query Cache Configuration

#

querycachelimit = 6M

querycachesize = 72M