Hi everyone,
I'm coloradok5's host, and we've been working together to sort out his server's problems. I thought I'd interject with his server's configurations and some statistics from his database. Any additional questions, please feel free to shoot, and I'll do the best I can.
Here's some relevant settings on his mysql server:
set-variable = max_connections=1500
set-variable = table_cache=2038
set-variable = thread_cache_size=50
set-variable = key_buffer=256M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=1M
A good rule of thumb for mysql settings over the years: It's the key_buffer: 1/3rd total system memory for a dedicated mysql server (a server that does nothing but mysql), 1/4th or less total system memory for a multipurpose server.
Following Jeffrey White's lead, from w3t_Posts:
Total Number of Posts: 336153
Unknown number of "lurkers" (how do you find that?)
sum(B_Counter) = 54114724
max(B_Counter) = 7599
Also, it looks like we've got 4567 Users.
Basically, the problem is that at 7pm - 9pm or so, the system starts getting too busy and starts swapping.
Any help or advice that you guys could give would be great.
jason
