List:General Discussion« Previous MessageNext Message »
From:Bruce Ferrell Date:September 8 2011 10:34am
Subject:Re: trying to change wait_timeout
View as plain text  
On 09/08/2011 02:56 AM, Johan De Meersman wrote:
> ----- Original Message -----
>> From: "Bruce Ferrell"<bferrell@stripped>
>> 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.

trying to change wait_timeoutBruce Ferrell8 Sep
  • Re: trying to change wait_timeoutJohan De Meersman8 Sep
    • Re: trying to change wait_timeoutBruce Ferrell8 Sep
      • Re: trying to change wait_timeoutAndrew Moore8 Sep
        • Re: trying to change wait_timeoutSuresh Kuna9 Sep
        • Re: trying to change wait_timeoutBruce Ferrell11 Sep