On 09/08/2011 02:56 AM, Johan De Meersman wrote:
----- Original Message -----
From: "Bruce Ferrell"<bferr...@baywinds.org>
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=arch...@jab.org
