[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Sleeping process not getting droped
From:       <badtothebone () odi ! com ! br>
Date:       2004-01-31 20:54:48
Message-ID: 00c801c3e83d$88f591f0$0c01a8c0 () blindguardian
[Download RAW message or body]


Hello Alll

Mysql is geting stucked by sleeping process like the table:

+-----+---------+-----------+----------+---------+------+-------+-----------------------+
| 421 | postfix | localhost | postfix2 | Sleep   | 121  |       | NULL                  |
| 422 | postfix | localhost | postfix2 | Sleep   | 61   |       | NULL                  |
| 423 | postfix | localhost | postfix2 | Sleep   | 116  |       | NULL                  |
| 424 | postfix | localhost | postfix2 | Sleep   | 116  |       | NULL                  |
| 425 | postfix | localhost | postfix2 | Sleep   | 24   |       | NULL                  |
| 426 | postfix | localhost | postfix2 | Sleep   | 24   |       | NULL                  |
| 427 | postfix | localhost | postfix2 | Sleep   | 16   |       | NULL          
| 412 | postfix | localhost | postfix2 | Sleep   | 21   |       | NULL                  |
| 413 | postfix | localhost | postfix2 | Sleep   | 21   |       | NULL                  |
| 414 | postfix | localhost | postfix2 | Sleep   | 21   |       | NULL                  |
| 415 | postfix | localhost | postfix2 | Sleep   | 21   |       | NULL                  |
| 416 | postfix | localhost | postfix2 | Sleep   | 13   |       | NULL                  |
| 417 | postfix | localhost | postfix2 | Sleep   | 13   |       | NULL                  |
| 418 | postfix | localhost | postfix2 | Sleep   | 12   |       | NULL                  |
| 419 | postfix | localhost | postfix2 | Sleep   | 12   |       | NULL                  |
| 420 | root    | localhost | NULL     | Query   | 0    | NULL  | show full processlist |
+-----+---------+-----------+----------+---------+------+-------+-----------------------+
55 rows in set (0.00 sec)


I have set in my.cnf to drop the sleeping process to: 

set-variable=wait_timeout=5
set-variable=interactive_timeout=5

Some process are droped, some are not
Eventualy all connections get stucked and none can connect to mysql.


Any ideas?

Tks

 ngelo





[prev in list] [next in list] [prev in thread] [next in thread]