From: Johan De Meersman Date: November 30 2011 5:03pm Subject: Re: Global Variables List-Archive: http://lists.mysql.com/mysql/226405 Message-Id: <4d2725ae-40d9-4c47-a0f9-d31030438871@zimbra> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message ----- > From: "Stdranwl" > > So then no use of setting 3G sort buffer in my.cnf untill system will > take a rebot? > I was in the impression that 10M will be used and it will be > scratched to 3G whenever required as same is set globally? No, you've got it the wrong way round. When a new client connects, it's session variables are initialised from the global values. Thus, if your global value is 3G, new clients will get a session value of 3G. If your appplication or the client subsequently decides to set the session value to 10M, *then* it will be 10M. Open a new terminal and make a new connection, then look at the session variables. If they're still different from the global value, something is setting them upon connect. Check for a .my.cnf file in your homedir, aliases or wrapper scripts for the mysql client, etc. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel