Hi Brett and all:
I just wanted to let you know about some changes that I made on Friday that really seemed to do it.
1. Based on responses here and looking at our own system and users, etc. We made the following changes in my.cnf:
[mysqld]
port = 3306
skip-locking
set-variable = max_connections=1500
set-variable = key_buffer=500M
set-variable = join_buffer=15M
set-variable = record_buffer=7M
set-variable = sort_buffer=15M
set-variable = table_cache=2038
set-variable = thread_cache_size=256
[myisamchk]
set-variable = key_buffer=256M
set-variable = sort_buffer=256M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
2. We also turned off the full new post tracking (which, if I had ready the text next to that setting I may have thought to change that earlier).
3. We removed that check referer line which was preventing a LOT of people from posting.
After doing that, the server is running EXCEPTIONALLY faster. With more users than ever before it's only maxing out at about 80% and even then it's only for a heartbeat.
Thanks to everyone here who posted helpful suggestions and thanks to Brett for doing our strategic growth analysis!! <img border="0" title="" alt="[Wink]" src="images/icons/wink.gif" />
Jeffrey
