MYSQL + Genesis Theme Performance Issues
I ran multiple stress tests on my site, and it appears the Genesis theme is at the heart of the problem with an issue I am having with mysql and maximum threads. When I have the Genesis activated and I run my stress test, I am able to easily spike to 75+ mysql threads (connections to mysql that are in sleep state). This means the query's are done, but the db connection is not being closed properly. When I run the same test with the out of the box theme, I never spike about 15 and they close much faster. Genesis appears to either be holding on to open connections longer or isn't closing them properly. I decided to hit up a few Genesis hosted sites, and just holding down my F5 key in chrome for about 30 seconds was enough to take down about half the sites I try. My site takes about 45 seconds to take down (as I have a 150 max. thread setting my mysql.cnf). So this means wordpress installs running Genesis are much more subject to DOS attacks, and it would be nice to get some insight to why this is?
The whole reason I ran into this issue is because my site is scanned by a security company for vulnerabilities, and their scanner took my site down. The scanner try's a bunch of bogus url's looking for vulnerabilities (about 15 requests per second), and because my 404 pages go through the Genesis framework it takes down my box in a matter of minutes!
Anyone have some insight to what I could do to force Genesis to close it's connections quicker?