Re: set global does not work

2006-12-06 Thread Visolve DB Team 
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: 
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]
> 
>

RE: set global does not work

2006-12-06 Thread dvd 
 
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]