List:General Discussion« Previous MessageNext Message »
From:Andrew Moore Date:September 8 2011 1:55pm
Subject:Re: trying to change wait_timeout
View as plain text  
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 <bferrell@stripped>wrote:

> 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.
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?**
> unsub=eroomydna@stripped<http://lists.mysql.com/mysql?unsub=1
>
>

Thread
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