MySQL Forums
Forum List  »  Newbie

query_cache_type
Posted by: hmt pro
Date: July 07, 2014 05:05AM

mysql 5.0.26, myisam ( don´t bother me with innodb !!! )

not much information available for the cache itself.
I could activate it but setting query_cache_type to 2 does not work, i can only set to 1 or 0.
When I do
SET GLOBAL query_cache_type =2;
it´s in mode 1 ( obviously using cache in any case ),
SET GLOBAL query_cache_type =0;
turns it off , but
SHOW VARIABLES LIKE 'query_cache_type'
says it´s on..

Options: ReplyQuote


Subject
Written By
Posted
query_cache_type
July 07, 2014 05:05AM
July 07, 2014 05:14AM
July 08, 2014 11:44PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.