Quote:
Originally Posted by LA-Aquarium
I had to disable the mod for a while until I can get it fixed.
Should I be editing the ideal_chat_update_stream.php
It caused my forum database connections to max out.
|
How many members does your site average online at a time? What is your mysql max connections set at? Also what kind of hosting is your site on?
You can update the sleep setting from 1 second to 2, and the stream will use half the resources of before but this won't lower the connection count from the script. Most likely you just need to raise your mysql max connections as it sounds like its set to low. The extra connections generated from this script will basically sit idle till the sleep timer expires then they run 1 query to check for updates. So the extra connections from the script should basically sit idle 90-95% of the time depending on query response time.