Hi Daniel, Yes, query_cache_type is 1 by default if you don't set it. :-) It's not used by default, however, because query_cache_size is 0. You need to set query_cache_size to 16M, 32M, etc.
Hope that helps. Matt ----- Original Message ----- From: "Daniel Kasak" Sent: Thursday, September 25, 2003 12:49 AM Subject: Query Cache not being used... > Hi all. > > I've set an option in the my.cnf file ( for a 4.0.14 server ): > > [mysqld] > query_cache_type = 1 > > and restarted the server. > > The query cache is supposed to be available. "SHOW VARIABLES LIKE > 'have_query_cache'" returns 'YES' as described in the documentation. But > all the qcache_* status indicators are always 0. > > Is there anything else I'm supposed to do to turn the query cache on? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
