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 <bferr...@baywinds.org>wrote: > On 09/08/2011 02:56 AM, Johan De Meersman wrote: > >> ----- Original Message ----- >> >>> From: "Bruce Ferrell"<bferr...@baywinds.org**> >>> To: mysql@lists.mysql.com >>> 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=eroomy...@gmail.com<http://lists.mysql.com/mysql?unsub=eroomy...@gmail.com> > >
