From: Johan De Meersman Date: November 30 2011 12:27pm Subject: Re: Global Variables List-Archive: http://lists.mysql.com/mysql/226398 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message ----- > From: "Reindl Harald" > > DO NOT REPLY OFF-LIST Also, do not shout :-) > the difference is "set" or "set global" Same for show, and 'show variables' is implicitly the same as the clearer 'show session variables'. > global is what would be used if the thread does not change it That is, at connect time all the session variables are initialized from the global variables; and the session can then override them. For status variables (like com_*), the globals are cumulative counters, while the session ones are this-session counters. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel