List:Internals« Previous MessageNext Message »
From:Yves Trudeau Date:March 7 2012 2:38am
Subject:Re: have_query_cache and query_cache_type
View as plain text  
   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.



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 Audit FunctionAruna Karunarathna5 Feb
  • Re: MySQL Audit FunctionAntony T Curtis5 Feb
    • Re: MySQL Audit FunctionPaul DuBois12 Apr
      • Re: MySQL Audit FunctionAntony T Curtis13 Apr
        • Re: MySQL Audit FunctionPaul DuBois13 Apr
          • RE: MySQL Audit FunctionRick James18 Apr
            • Re: MySQL Audit FunctionSergei Golubchik18 Apr
  • re: MySQL Audit FunctionMichael Widenius21 Feb
    • Re: re: MySQL Audit FunctionSergei Golubchik22 Feb
      • memcache vs.query_cacheRevathi Rangachari23 Feb
        • re: memcache vs.query_cacheMichael Widenius24 Feb
          • re: memcache vs.query_cacheRevathi Rangachari25 Feb
          • Re: memcache vs.query_cacheRick James27 Feb
            • query_cache_type and Aborted ClientsRevathi Rangachari1 Mar
              • Re: query_cache_type and Aborted ClientsRick James1 Mar
                • Re: query_cache_type and Aborted ClientsRevathi Rangachari5 Mar
                  • Re: query_cache_type and Aborted ClientsRick James5 Mar
                    • have_query_cache and query_cache_typeRevathi Rangachari6 Mar
                      • Re: have_query_cache and query_cache_typeYves Trudeau7 Mar
                • Slow query log file not getting updatedRevathi Rangachari20 Mar
                  • Re: Slow query log file not getting updatedBaron Schwartz21 Mar