Ok
Each Status ID is a thread and you can kill them with KILL "thredidnumber".
Delayed insert is just a sql insert command that has low priority.
Sleep is a thread that is kept open incase you would like to use it agene.
Question: How many thread do you allow on your set-up?
You have hit 102 threads and have had 4 questions that have been over the
long question time set....
One thing to look for the pconnects over connects in your programs!
Hope this helps?
Simon
-----Original Message-----
From: Mirek Novak [mailto:[EMAIL PROTECTED]]
Sent: 26 June 2001 14:54
To: [EMAIL PROTECTED]
Subject: Sever hangs after ...
Hi,
what does mean following ...
mysql> show processlist;
+--------+------+-----------+----------+----------------+-------+-----------
------+------------------+
| Id | User | Host | db | Command | Time |
State | Info |
+--------+------+-----------+----------+----------------+-------+-----------
------+------------------+
| 5 | | | autocz | Delayed_insert | 1 |
Waiting on cond | dt |
| 12 | | | abanners | Delayed_insert | 1 |
Waiting on cond | statistics |
| 18 | | | formule1 | Delayed_insert | 3 |
Waiting on cond | pristup |
| 9405 | | | carnext | Delayed_insert | 6863 |
Waiting on cond | dailytraffic |
| 10782 | | | auto_cz | Delayed_insert | 18453 |
Waiting on cond | obrazky_stat |
| 277825 | | | autonews | Delayed_insert | 67010 |
Waiting on cond | pristup |
| 277826 | | | autonews | Delayed_insert | 68166 |
Waiting on cond | obrazky_stat |
| 314346 | | | formule1 | Delayed_insert | 56880 |
Waiting on cond | obrazky_stat |
| 350836 | root | localhost | auto_cz | Sleep | 189 |
NULL | NULL |
| 361247 | root | localhost | auto_cz | Sleep | 1910 |
NULL | NULL |
| 361471 | root | localhost | auto_cz | Sleep | 1919 |
NULL | NULL |
| 364842 | root | localhost | auto_cz | Sleep | 291 |
NULL | NULL |
| 365388 | root | localhost | auto_cz | Sleep | 184 |
NULL | NULL |
| 365940 | root | localhost | auto_cz | Sleep | 151 |
NULL | NULL |
| 365950 | root | localhost | auto_cz | Sleep | 67 |
NULL | NULL |
| 367387 | root | localhost | auto_cz | Sleep | 1126 |
NULL | NULL |
| 367567 | root | localhost | auto_cz | Sleep | 1248 |
NULL | NULL |
| 367903 | root | localhost | auto_cz | Sleep | 474 |
NULL | NULL |
| 368390 | root | localhost | auto_cz | Sleep | 869 |
NULL | NULL |
| 368810 | root | localhost | auto_cz | Sleep | 2010 |
NULL | NULL |
| 368924 | root | localhost | auto_cz | Sleep | 736 |
NULL | NULL |
| 368995 | root | localhost | auto_cz | Sleep | 119 |
NULL | NULL |
| 370074 | root | localhost | auto_cz | Sleep | 301 |
NULL | NULL |
| 370141 | root | localhost | auto_cz | Sleep | 805 |
NULL | NULL |
| 370532 | root | localhost | auto_cz | Sleep | 796 |
NULL | NULL |
| 370613 | root | localhost | auto_cz | Sleep | 464 |
NULL | NULL |
| 370677 | root | localhost | auto_cz | Sleep | 452 |
NULL | NULL |
| 371171 | root | localhost | auto_cz | Sleep | 92 |
NULL | NULL |
| 371216 | root | localhost | auto_cz | Sleep | 1557 |
NULL | NULL |
<cut>
and after while server goues to hell ...
Server status is ....
mysql> status
--------------
mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686)
Connection id: 456292
Current database:
Current user: root@localhost
Server version 3.22.32
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 day 17 hours 5 min 22 sec
Threads: 102 Questions: 9955492 Slow queries: 4 Opens: 39241 Flush
tables: 1 Open tables: 63
--------------
TIA, Mirek Novak
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php