I saw a link to an EV1 thread about tuning mysql for better handeling.
Alot of the responses where a little confusing to me so I was hoping maybe someone could provide what they have done.
The servers all have 1gb of ram and are AMD XP3000 cpu's with IDE disks.
I added the following lines to my.cnf yesterday.
query_cache_type=1
query_cache_limit=1M
query_cache_size=16M
table_cache=1024
key_buffer=128M
Overall the load that mysql puts on the server went down but I also feel that the performance of mysql has gone down aswell. Im trying to find a nice balance between performance and load.
Alot of the responses where a little confusing to me so I was hoping maybe someone could provide what they have done.
The servers all have 1gb of ram and are AMD XP3000 cpu's with IDE disks.
I added the following lines to my.cnf yesterday.
query_cache_type=1
query_cache_limit=1M
query_cache_size=16M
table_cache=1024
key_buffer=128M
Overall the load that mysql puts on the server went down but I also feel that the performance of mysql has gone down aswell. Im trying to find a nice balance between performance and load.