News for hackers. Stuff that matters.
Re:10 Million hits a day with Wordpress using a $15 server by jstalin on Friday March 30, 2012 @09:17AM (#3775765)
What about memory usage with MySql? I've found that to be a significant bottleneck with wordpress sites. A basic wordpress installation doesn't use the database much, but if you add just a few plugins, things start to jump pretty quickly.
Re:10 Million hits a day with Wordpress using a $15 server by dugmartin on Friday March 30, 2012 @09:44AM (#3775868)
Varnish takes the load off by caching the results from Wordpress. The Total Cache plugin handles purging cache entries when you update posts/pages.

If you want to see how many queries Wordpress runs even for a simple post install this plugin I wrote at my last job. It shows a log of queries in the page footer if you are logged in as admin.

http://wordpress.org/extend/plugins/wpdb-profiling/

Re:10 Million hits a day with Wordpress using a $15 server by EwanToo on Friday March 30, 2012 @09:21AM (#3775780)
I didn't play around with MySQL in those settings at all, mostly because the last thing you actually want is a query hitting the database.

You're right though, if you start adding a few less well coded plugins, then you can start hitting the database a lot, for no really good reason.

Re:10 Million hits a day with Wordpress using a $15 server by jamesgeck0 on Friday March 30, 2012 @09:32AM (#3775825)
The caching software and http accelerator probably mitigate the need to hit the database at all.