Anybody have a forum? few quick questions.
what version of sql are you using on your forum?
even if you don't know the answers to questions below - could you perhaps state what version of sql your site is running.
bonus points if you can answer any questions below.
the reason I ask these questions is because after a while the server bogs down and server resources are high as reported by the host provider.
- do you use a robots.txt? is it unusual for googlebot and bingbot to make 40% of the the page requests.
did you tune sql parameters? if so, what
got any suggestions - where to look?
Figures in parentheses refer to the 7-day period
Average successful requests per day: 40,075 (55,559)
Successful requests for pages: 614,890 (85,963)
Average successful requests for pages per day: 7,162 (12,280)
Failed requests: 42,944 (670)
Redirected requests: 61,973 (1,058)
here is a sample of show status.
anyone see issues or does something look odd?
aside from aborted clients and aborted connections
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.