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.
[ Parent
| on HN ]
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.
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.