[Zope] MySQL thread connection question

[aschmidt at fredericksburg.com]

Mornin,

We use ZEO and two public clients on Linux along with Squid and POUND on one box. All this is attached to MySQL4 on the same box.

For reasons unknown the clients will thread-hang for long periods and all the threads will fill up and make the client unreachable. POUND will still try to direct requests to the full client and so cause our 'www' to become unreachable.

When this happens we manually pull the rug from the unresponsive client and restart it. Eveything is fine once again.

However, in watching the threads in MySQL, there will be many sleeping threads that have lived for MUCH longer than any of the running zope clients. We are assuming that the zope client connections are established when the client comes up and are maintained whether used or not. When we kill the client those threads stay there and new connections are made to MySQL. 

As I write this I think its turning into more of a MySQL topic than zope but is there anything that can be done to kill off the old sleeping MySQL threads or have the zope client use the ones that are there already??

Sort of confusing but thought I would throw this out.

Thanks

Allen