On Fri, Feb 11, 2005, ""mc"" <[EMAIL PROTECTED]> said:
>>> But does that imply there is a option to turn that on? A grep -ri >>> SQL_CACHE >>> * from the top level of the source tree returned an empty list. :) >>> or perhaps do I need to manually hack the src to enable this? >> >> Neither: >> http://dev.mysql.com/doc/mysql/en/query-cache-configuration.html > > To my understanding, mysql does not automatically cache resultsets by > default even if you set it to yes. Though it *allows* the resultsets to be > cached. I think an explicit SELECT SQL_CACHE is needed. It's the opposite of that; quoting from the page I linked above: If the query cache is enabled, the query_cache_type variable influences how it works. This variable can be set to the following values: * A value of 0 or OFF prevents caching or retrieval of cached results. * A value of 1 or ON allows caching except of those statements that begin with SELECT SQL_NO_CACHE. * A value of 2 or DEMAND causes caching of only those statements that begin with SELECT SQL_CACHE. Aaron
