Archives by date
You are browsing the site archives by date.
By S on October 16, 2008
For those wondering how to do query caching here is a quick run down. 1) Edit the MySQL conf at the following to /etc/my.cnf for a 26M query cache use: query_cache_type = 1 query_cache_size = 26214400 2) Restart MySQL /etc/init.d/mysqld restart 3) Login to MySQL and run the following: mysql> SET GLOBAL query_cache_size = 26214400; […]
By S 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 […]