I'm running the following stack:
2-CPU 8-core Intel Xeon CPU, 8GB RAM
Windows Server 2008 R2 64-bit
(if you need any more information let me know)
What happens is that shortly after apache comes online the server response times start out at about 1-2 seconds. Then they quickly (within a few min) rise to 30 - 120 seconds (apache is configured to kill the request after 120 seconds). I've found that stopping and starting apache seems to solve the problem for a few min. However, bouncing apache continually is not a good solution.
The apache error logs seem to indicate that the time is spent in qa-include/qa-db.php. I've checked the queries, and they can be anything from the query that loads the landing page, to a 'show tables;' This leads me to beleive that it's not really the queries, since it seems to stop at a random query, but a general connection problem with MySQL.
To my question, has anyone seen behavior like this before and found a solution?