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

Hi,
this is a compile option, the variable have_query_cache
is there to illustrate if the current binary has been compiled with the
query cache or not.

Regards,

Yves

On 12-03-06 06:32 PM, Revathi Rangachari wrote:
--
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe: http://lists.mysql.com/internals