[Zope] Re: MySQL thread connection question

[cklinger]

aschmidt at fredericksburg.com wrote:
Hello
> 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.
Nearly the same configuration, i think the same Problem!
> 
> 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.
We do the same, unfortunately! Without ZEO it seams we don not have the 
problem. Or not so often.
> 
> 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. 
How do you see these treads?
> 
> 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
> 
Christian