Hi
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.
'wait_timeout' variable : The number of seconds the server waits for activity
on a non-interactive connection before closing it. This timeout applies only to
TCP/IP connections, not to connections made via Unix socket files, named pipes,
or shared memory.
'interactive_timeout' variable's value or wait_timeout variables values
-depends on the type of client (as defined by the CLIENT_INTERACTIVE connect
option to mysql_real_connect())
Thanks
ViSolve DB Team.
----- Original Message -----
From: Sayed Hadi Rastgou Haghi
To: Visolve DB Team
Cc: mysql@lists.mysql.com
Sent: Tuesday, November 07, 2006 4:12 PM
Subject: Re: wait_timeout help
Thanks again
I have some questions that may help me explain my problem well.
1- What's this mean:
mysql> SHOW PROCESSLIS;
+------+-------+----------------------+--------+---------------+---------+--------+-----------------+
| Id | User | Host | db | Command | Time | State | Info
|
+------+-------+----------------------+--------+---------------+---------+---------+----------------+
| 1 | usr | myhost:36336 | mydb | Sleep | 2587 | | NULL
|
| 11 | usr | myhost:36341 | mydb | Sleep | 2587 | | NULL
|
| 12 | usr | myhost:36348 | mydb | Sleep | 2587 | | NULL
|
| 3732| usr | myhost:43940 | mydb | Sleep | 2587 | | NULL
|
+------+-------+----------------------+--------+---------------+---------+---------+----------------+
Are these processes idle?
If yes why MySQL doesn't kill them?
2- If I set wait_timeout variable, will they be killed on that time?
3- If I set interactive_timeout, what will happen to queries that take time
longer than interactive_timeout?
On 11/7/06, Visolve DB Team <[EMAIL PROTECTED]> wrote:
Hi
Try command line option, like
mysql >set @@session.wait_timeout=15;
mysql> show variables;
Thanks
Visolve DB Team.
----- Original Message -----
From: "Sayed Hadi Rastgou Haghi" < [EMAIL PROTECTED]>
To: "Visolve DB Team" <[EMAIL PROTECTED]>
Cc: < mysql@lists.mysql.com>
Sent: Tuesday, November 07, 2006 3:21 PM
Subject: Re: wait_timeout help
> Thanks
> But this sets. GLOBAL wait_timeout variable.
> Cab be seen by SHOW GLOBAL VARIABLES not by SHOW VARIABLES;
>
> On 11/7/06, Visolve DB Team <[EMAIL PROTECTED]> wrote:
>>
>> Hi
>>
>> specify it in the .cnf file in the mysqld options: wait_timeout=x
>> or specify it at the command line : set wait_timeout=x
>> or start mysqld with --wait_timeout=x along with other options.
>>
>> Thanks
>> ViSolve DB Team
>> ----- Original Message -----
>> From: "Sayed Hadi Rastgou Haghi" <[EMAIL PROTECTED]>
>> To: <mysql@lists.mysql.com>
>> Sent: Tuesday, November 07, 2006 2:08 PM
>> Subject: wait_timeout help
>>
>>
>> > Dear All,
>> >
>> > I want to set wait_timeout variable on mysqld startup.
>> > Is there any way to do that?
>> >
>> > --
>> > Sincerely,
>> > Hadi Rastgou
>> > A Google Account is the key that unlocks the world of Google.
>> > <a href= "http://www.spreadfirefox.com/?q=affiliates&id=0&t=1";>
>> > Get
>> > FireFox! </a>
>> >
>>
>>
>
>
> --
> Sincerely,
> Hadi Rastgou
> A Google Account is the key that unlocks the world of Google.
> <a href= " http://www.spreadfirefox.com/?q=affiliates&id=0&t=1";>
> Get
> FireFox! </a>
>
--
Sincerely,
Hadi Rastgou
A Google Account is the key that unlocks the world of Google.
<a href= "http://www.spreadfirefox.com/?q=affiliates&id=0&t=1";> Get
FireFox! </a>
