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
Well
to clear threads just type KILL "threadID".
You get the thread ID from "Show Processlist".
If the threads are sleeping it the client software that is making this
happen(JDBS)
So there are several thing to do
Change the length in MySQL that sleeping threads are closed (8h standard)...
