MySQL Query Caching Part II
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; […]
MySQL Query caching
We implemented MySQL query caching yesturday and the results are quite impressive. ab -n 100 -c 40 https://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 […]
Content compression added
Added content compression to Apache using mod_deflate AddOutputFilterByType DEFLATE text/html text/plain text/xml text/javascript no dramtic changes in speed but every bit counts.
Apache benchmarking UBC Blogs
Just had a complaint about response time on the system. Ran some benchmarks here is a result from the homepage using: ab -n 40 -c 20 Time per request: 2.152 [ms] (mean, across all concurrent requests) Transfer rate: 10059.36 [Kbytes/sec] received This is very fast. Checked the server logs nothing out of the norm. Makes […]