MySQL Forums
Forum List  »  Newbie

Re: query_cache_type
Posted by: Rick James
Date: July 08, 2014 11:44PM

SET GLOBAL query_cache_type = ... -- changes the _global_ value.

SHOW VARIABLES -- looks at the _session_ values.

Logging in _initializes_ the _session_ values to the _global_ values.

Hence, exiting and reentering (or otherwise starting a new connection) picked up the GLOBAL value.

This is a generic concept with many of the VARIABLES. There are exceptions.

Options: ReplyQuote


Subject
Written By
Posted
July 07, 2014 05:05AM
July 07, 2014 05:14AM
Re: query_cache_type
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.