Hi,
have a look at show status,
and here for the variable
wait_uptime in seconds. How long it is.
Regards Gerlinde
At 13:54 10.07.01 +0100, Andy C wrote:
>Please excuse if this is a FAQ or well known effect. I'm running mySql
>version 3.23.36 on a Winnt 4.0 Sp6a machine. It's connected to
>a jsp page (running on resin2..0.0) through mmsql JDBC drivers.
>
>Over a period fo days I'm seeing a build up of sleeping threads which will
>eventually
>meet the max_threads value. Now I hasten to add I am really only
>a beginer with mySql.
>
>Is there some way I can clear these sleeping threads and free up Id's? Is
>there
>a way to "garbage" collect threads that have been sleeping for maore than
>say
>24 hours ?
>
>I've attached a potion of the "Show Processlist" output.
>
>Andy C
>Editor r2 project
>http://www.r2-dvd.org
>
>
>+------+-----------+---------------------------------+---------+---------+--
>------+-------+------------------+
>| Id | User | Host | db | Command |
>Time | State | Info |
>+------+-----------+---------------------------------+---------+---------+--
>------+-------+------------------+
>| 1 | installer | localhost | Stories | Sleep |
>247744 | | NULL |
>| 2 | installer | localhost | Stories | Sleep |
>247783 | | NULL |
>| 3 | installer | localhost | Stories | Sleep |
>247809 | | NULL |
>| 4 | installer | localhost | Stories | Sleep |
>247754 | | NULL |
>| 5 | installer | localhost | Stories | Sleep |
>247826 | | NULL |
>| 19 | installer | localhost | NULL | Sleep | 2
>| | NULL |
>| 214 | installer | localhost | film | Sleep |
>9749 | | NULL |
>| 405 | installer | localhost | Stories | Sleep |
>247733 | | NULL |
>| 406 | installer | localhost | Stories | Sleep |
>246930 | | NULL |
>| 417 | installer | localhost | Stories | Sleep |
>246954 | | NULL |
>| 434 | installer | localhost | Stories | Sleep |
>246900 | | NULL |
>| 435 | installer | localhost | Stories | Sleep |
>246869 | | NULL |
>| 438 | installer | localhost | Stories | Sleep |
>104816 | | NULL |
>| 439 | installer | localhost | Stories | Sleep |
>183613 | | NULL |
>
>
>---------------------------------------------------------------------
>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
BLITZ Internet Service GmbH
Kronacher Strasse 41
D-96052 Bamberg, Germany
Tel. +49/951/9685160, Fax +49/951/9685164
http://www.blitz.net
---------------------------------------------------------------------
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
