UBC Blogs has been updated to the latest version of WordPress MU.

Changes in 2.6.3:

- minor security fix no new features.

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;

4) Check if it was loaded:

mysql> SHOW VARIABLES LIKE 'query_cache_size';
+------------------+----------+
| Variable_name    | Value    |
+------------------+----------+
| query_cache_size | 26214400 |
+------------------+----------+
1 row in set (0.00 sec)

5) Check the cache “hits”:

mysql> SHOW STATUS LIKE 'Qcache%';
+-------------------------+---------+
| Variable_name           | Value   |
+-------------------------+---------+
| Qcache_free_blocks      | 1079    |
| Qcache_free_memory      | 4635984 |
| Qcache_hits             | 210991  |
| Qcache_inserts          | 52877   |
| Qcache_lowmem_prunes    | 17821   |
| Qcache_not_cached       | 23497   |
| Qcache_queries_in_cache | 2273    |
| Qcache_total_blocks     | 6990    |
+-------------------------+---------+
8 rows in set (0.00 sec)

6) Compare that to the questions:

mysql> SHOW STATUS LIKE ‘Questions%’;
+—————+——–+
| Variable_name | Value |
+—————+——–+
| Questions | 354695 |
+—————+——–+
1 row in set (0.00 sec)

from this we can determine that at that point roughly 59% 210991/354695 of the database queries are “cached”.

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.

UBC Blogs has been updated to the latest version of WordPress MU.

Changes in 2.6.2:

- minor bug fixes no new features.

We implemented MySQL query caching some might notice a slight improvement in speed.

For those wanting to include math symbols in their posts WP LaTeX is now enabled.

For more info see the WP LaTeX FAQ.

Thanks goes to Alex T. our new part time student helper for tweaking the plugin.