Hi Try
mysql >set @@session.wait_timeout=1000; mysql> show variables; According to the VARIABLE "wait_timeout" [default: 28800 seconds] a running MySQL daemon clears up idle connections if their "idle period" > "wait_timeout". so the sleeping threads will be automatically cleared if the time exceeds 'wait_timeout' variable value. Thanks ViSolve DB Team. ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Thursday, December 07, 2006 11:52 AM Subject: RE: set global does not work > > Hi: > I open a connection via mysql > mysql>show global variables like 'wait_timeout' > --> 28800 > mysql> set global wait_timeout = 1000; > mysql>exit; > reopen mysql > mysql> show session variables like 'wait_timeout'; > --> 28800 > I expect session value to be 1000 according the doc, as it should be given > the global value > when a new connection is established. > Thanks > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
