From: Andrew Moore Date: September 8 2011 1:55pm Subject: Re: trying to change wait_timeout List-Archive: http://lists.mysql.com/mysql/225663 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=20cf3056396d213c3b04ac6e68b2 --20cf3056396d213c3b04ac6e68b2 Content-Type: text/plain; charset=ISO-8859-1 Check that you're looking at the variable in the GLOBAL scope not the SESSION scope. SHOW GLOBAL VARIABLE ... Andy On Thu, Sep 8, 2011 at 11:34 AM, Bruce Ferrell wrote: > On 09/08/2011 02:56 AM, Johan De Meersman wrote: > >> ----- Original Message ----- >> >>> From: "Bruce Ferrell" >>> To: mysql@stripped >>> Sent: Thursday, 8 September, 2011 3:10:16 AM >>> Subject: trying to change wait_timeout >>> >>> I've read the documentation on MySQL for version 5.1 and it says all >>> I have to do is to place the following: >>> wait_timeout=xxx >>> under [mysqld] >>> >> That, and restart the service, of course. You *did* think of restarting >> the service, I trust? :-p >> >> That being said, it is also a dynamic variable, so if you didn't restart, >> prefer not to restart *and* are certain your config file is correct; you can >> also do "set global wait_timeout=xxx" to have it take effect immediately for >> all new sessions. Yes, that means you'll have to disconnect/reconnect to see >> the change in your own session. >> > > Good question to ask. Yes, I did restart mysql. Both before and after > show variables like 'wait_time%' returns 28800. Most confusing. > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?** > unsub=eroomydna@stripped > > --20cf3056396d213c3b04ac6e68b2--