View Single Post
  #8  
Old 22nd August 2006, 12:29
drake drake is offline
Junior Member
 
Join Date: Aug 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default MySQL connection errors - maybe fixed

Hi
I've been fiddling with the MySQL settings in my.cnf and so far, the errors have stopped. Here are the settings that I'm using:
skip-locking
key_buffer = 64M
max_allowed_packet = 16M
table_cache = 1024
sort_buffer_size = 2M
net_buffer_length = 8K
read_buffer_size = 1M
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
thread_cache_size = 64
wait_timeout = 900
connect_timeout = 10
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
max_connections = 600

Hopefully it'll stay fixed!

Thanks for the replies.
Reply With Quote