Check that you're looking at the variable in the GLOBAL scope not the
SHOW GLOBAL VARIABLE ...
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:
>>> 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?**