I've a pretty simple question...
Why is the MySQL query cache disabled by default?
In most packaged versions of MySQL I've come across the defaults values are:
query_cache_type = 1 query_cache_size = 0
This essentially disables the query cache by default.
There are many other buffers and limits which are set with a sensible default value. Since the query cache is completely transparent to applications, why have it disabled?
I find myself enabling the query cache and the slow query log automatically every time I deploy a new MySQL box, so just curious as to the logic of the defaults.