MySQL Query caching

by Scott McMillan on October 15, 2008

We implemented MySQL query caching yesturday and the results are quite impressive.

ab -n 100 -c 40 http://blogs.ubc.ca/blog/category/community/latest-posts/

Requests per second:  325.78 [#/sec] (mean)
Time per request:       122.782 [ms] (mean)
Time per request:       3.070 [ms] (mean, across all concurrent requests)

We now have PHP APC opcode caching, content caching with WP-Super-Cache, content compression with mod_deflate and the MySQL Query caching… still alot more tweaks that can be done but this is a good foundation.

{ 1 trackback }

UBC Blogs » Blog Archive » UBC Blogs Upgraded to 2.6.2
10.15.08 at 3:18 pm

{ 0 comments… add one now }

Leave a Comment

You can use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>