List:General Discussion« Previous MessageNext Message »
From:Bruce Ferrell Date:September 8 2011 2:03pm
Subject:Re: trying to change wait_timeout
View as plain text  
That's the ticket!  Thanks


On 09/08/2011 06:55 AM, Andrew Moore 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<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