View Single Post
  #3  
Old 13th February 2008, 21:04
gAnDo gAnDo is offline
Junior Member
 
Join Date: Oct 2007
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks, I had previously looked in there but had not noticed much.

My host had a look at my my.cnf file today and seemingly it was not as optimized as I thought...

My original (the parts he changed)
Code:
key_buffer = 512M
max_allowed_packet = 1M
table_cache = 2000
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
thread_cache_size = 8
changed
Code:
key_buffer = 256M
max_allowed_packet = 64M
table_cache = 128M
sort_buffer_size = 32M
read_buffer_size = 32M
read_rnd_buffer_size = 16M
thread_cache_size = 64M
I think the major change was that the table_cache variable was lowered dramatically (we have 2GB RAM) which seemed to have been using up most of the RAM.

Do you have any more recommendations for optimizing mysql for 2GB of RAM with Apache running?

Thanks again.
Reply With Quote