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 version10 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
RE: Sever hangs after ...
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 version10 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