Set the variable wait_timeout=xxx value under the mysqld section of the configuration file and restart the mysqld server.
Now check show global variables like 'wait_timeout"; It should be you xxx value what ever you set. On Thu, Sep 8, 2011 at 7:25 PM, Andrew Moore <eroomy...@gmail.com> wrote: > 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> > > > > > -- Thanks Suresh Kuna MySQL DBA
