have_query_cache and query_cache_type

Revathi Rangachari <[email protected]>
Newsgroups gmane.comp.db.mysql.devel
Message-ID <[email protected]>
Hi

(1)  Under what circumstances the have_query_cache can become 'NO'.

(2)  Is it possible to set it as 'YES'. When I tried to do that I get error message as - ERROR HY000: Variable 'have_query_cache' is a read only variable

(3) If have_query_cache is 'NO' and if I enable query_cache_type and set query_cache_size TO 128MB, will the queries be read from the query cache?

Thanks
Revathi R



-- 
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe:    http://lists.mysql.com/internals
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.