trying to change wait_timeout

Hi all,

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]

did it and show variable like '%wait%'

still show wait_timeout at 28800

as it does when I do a set global wait_timeout=10

What am I missing?

Thanks in advance,

Bruce Ferrell

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: trying to change wait_timeout

----- Original Message -----
> From: "Bruce Ferrell"
> 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.


--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: trying to change wait_timeout

On 09/08/2011 02:56 AM, Johan De Meersman wrote:
> ----- Original Message -----
>> From: "Bruce Ferrell"
>> 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=gcdmg-mysql-2@m.gmane.org

Re: trying to change wait_timeout

--20cf3056396d213c3b04ac6e68b2
Content-Type: text/plain; charset=ISO-8859-1

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 wrote:

> On 09/08/2011 02:56 AM, Johan De Meersman wrote:
>
>> ----- Original Message -----
>>
>>> From: "Bruce Ferrell"
>>> 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=eroomydna@gmail.com
>
>

--20cf3056396d213c3b04ac6e68b2--

Re: trying to change wait_timeout

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 Ferrellwrote:
>
>> On 09/08/2011 02:56 AM, Johan De Meersman wrote:
>>
>>> ----- Original Message -----
>>>
>>>> From: "Bruce Ferrell"
>>>> 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=eroomydna@gmail.com
>>
>>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: trying to change wait_timeout

--e89a8f647823d16dbb04ac7a946c
Content-Type: text/plain; charset=ISO-8859-1

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



--
Thanks
Suresh Kuna
MySQL DBA

--e89a8f647823d16dbb04ac7a946c--