One of the reasons to experiment with a visual interface is to see what options are available: the menus and buttons sometimes reveal choices that the written docs don’t. I was playing with the MySQL Administrator client I learned about earlier today, and was baffled by the discovery that I have no query caching.
Come to find out, there is some query caching on, but MySQL Administrator can’t find it. CocoaMySQL, on the other hand, while not as full-featured on administrative/health issues, does return some data on query cache rates.
And the command-line mysql client confirms it.
mysql> SHOW STATUS LIKE 'Qcache%';
+-------------------------+---------+
| Variable_name | Value |
+-------------------------+---------+
| Qcache_queries_in_cache | 851 |
| Qcache_inserts | 1668 |
| Qcache_hits | 14917 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 197 |
| Qcache_free_memory | 4230256 |
| Qcache_free_blocks | 1 |
| Qcache_total_blocks | 1725 |
+-------------------------+---------+
8 rows in set (0.00 sec)
What would be useful would be some direct query access through the “official” client, as you get with CocoaMySql.
Bug report filed with MySQL AB.
And just as quickly closed. For whatever reason, once I exited the app and restarted it, it is picking up the values now.