ZM problem because too many mysql threads
Posted: 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
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