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?
-- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]