ZM problem because too many mysql threads

loop · Post by **loop** » Wed Dec 08, 2004 3:05 pm

Hi,
I've noticed that ZM opens 1 or 2 new mysql threads when viewing an event. Those threads stay open afterwards. When threads count in mysql reaches 100 I get an error from mysql "too many open threads" and ZM doesn't work any more.

When viewing live stream one thread is opened and it's closed when I close the live camera window.

I check the threads status by entering bash command:
mysql zm

end then in mysql I type:
status

How can I avoid this problem (without restarting mysql every once in a while) ?

Best regards,
Darko

loop · Post by **loop** » Thu Dec 16, 2004 2:11 pm

I've solved it. There were instances of zms still running in the background, that's why mysql threads were left open.

D.