Fw: Anybody Help-me??? Problems with Time-Out

[Daniel Bronzeri Barbosa]

People I need Help...

TKS

Daniel

----- Original Message ----- 
From: "Daniel Bronzeri Barbosa" <daniel@stripped>
To: <win32@stripped>
Sent: Friday, January 16, 2004 8:37 AM
Subject: Anybody Help-me??? Problems with Time-Out


Hi Everybody,

     I am with some problems in connections and would like to know as I must
make to limit one thread for one determined time and  eliminate one thread
Killed, therefore these limit the use of connections in the server.

    Below I show to an example of mine processlist being that some of the 0
variable are configured as:

        set-variable = connect_timeout=20
        set-variable = wait_timeout=20
        set-variable = interactive_timeout=20

Grateful,

Daniel Barbosa


____________________________________________________________________________
____________________________
mysql> show processlist;
+----+------+----------------+---------+---------+------+-------+-----------
----
---+
| Id | User | Host           | db      | Command | Time | State | Info
   |
+----+------+----------------+---------+---------+------+-------+-----------
----
---+
| 20 | ODBC | 127.0.0.1:3236 | NULL    | Sleep   | 8    |       | NULL
   |
| 21 | root | 127.0.0.1:3267 | voicedb | Sleep   | 81   |       | NULL
   |
| 22 | root | 127.0.0.1:3268 | voicedb | Sleep   | 80   |       | NULL
   |
| 24 | ODBC | 127.0.0.1:3272 | NULL    | Query   | 0    | NULL  | show
processli
st |
+----+------+----------------+---------+---------+------+-------+-----------
----
---+
4 rows in set (0.00 sec)

mysql> kill 21
    -> ;
Query OK, 0 rows affected (0.00 sec)

mysql> show processlist;
+----+------+----------------+---------+---------+------+-------+-----------
----
---+
| Id | User | Host           | db      | Command | Time | State | Info
   |
+----+------+----------------+---------+---------+------+-------+-----------
----
---+
| 20 | ODBC | 127.0.0.1:3236 | NULL    | Sleep   | 8    |       | NULL
   |
| 21 | root | 127.0.0.1:3267 | voicedb | Killed  | 121  |       | NULL
   |
| 22 | root | 127.0.0.1:3268 | voicedb | Sleep   | 120  |       | NULL
   |
| 24 | ODBC | 127.0.0.1:3272 | NULL    | Query   | 0    | NULL  | show
processli
st |
+----+------+----------------+---------+---------+------+-------+-----------
----
---+
4 rows in set (0.00 sec)

mysql>

____________________________________________________________________