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