LawsHosting
Verified User
Server: Intel Dual Core with 2GB of ram in 32bit mode.
I would like to minimise the use of temporary tables being written to disk, however whatever size I set tmp_table_size and max_heap_table_size to (even 512M!), theres still 68%-80% of tables written to disk after 4 days.
from ./tuning_primer.sh:
I read somewhere that tmp_table_size and max_heap_table_size should be the same, but from peoples experience (as I've seen from forums), it will create more temp tables on disk. But I thought the purpose of these settings were to prevent (most) temp files being written to disk?
Maybe my other settings are getting in the way of this by hogging memory? (will paste my my.cnf if need be)
Any advice would be grateful
I would like to minimise the use of temporary tables being written to disk, however whatever size I set tmp_table_size and max_heap_table_size to (even 512M!), theres still 68%-80% of tables written to disk after 4 days.
from ./tuning_primer.sh:
This was when both were set to 128M by the way.
I read somewhere that tmp_table_size and max_heap_table_size should be the same, but from peoples experience (as I've seen from forums), it will create more temp tables on disk. But I thought the purpose of these settings were to prevent (most) temp files being written to disk?
Maybe my other settings are getting in the way of this by hogging memory? (will paste my my.cnf if need be)
Any advice would be grateful