Total Geek Thread
Charles Johnson
Wed Apr 2, 2008 at 12:13 pm PDT • Views: 212
Hey, anyone notice how much better LGF is behaving? The hamsters haven’t even hiccuped all week, and response time is greatly improved overall. The Safari browser has a cool Web Inspector that shows all kinds of stats about a web page as it loads, and it reports that loading the main LGF front page is now more than twice as fast, even at peak traffic times.
Geek stats: in the three days since I tweaked and restarted MySQL, 76.4% of the database queries have been served from the query cache. Huge savings there.
More huge savings from connection pooling, although that’s harder to measure. But the snappier response time is largely due to the fact that the most common database connections are able to take place without actually opening a new connection.
The real key to this, however, was installing a small cron job on the database server that monitors “sleeping” MySQL processes, and kills any that exceed the maximum persistent connection timeout. This is necessary because some MySQL processes live on past their scheduled timeout, and unless you cull the zombie herd periodically, they will pile up and choke the server. Let it go for a few hours, and they max out the possible MySQL connections. Then you have trouble.
More geek stats: in the 3 days the MySQL server has been up, it has served 65 million queries, out of which only 287 were “slow” — in other words, took more than a few seconds. Efficiency of key usage: 99.9%.
Frank says: