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?

--
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]



Reply via email to