Re: have_query_cache and query_cache_type

Yves Trudeau <[email protected]>
Newsgroups gmane.comp.db.mysql.devel
Message-ID <[email protected]>
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:
> 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.