Our server has too many connections opened and it seems to crash the MYSQL and we have to manually close all connections to regain stability. Does anyone know how this can be resolved. We do not want to set the connection number up to 1000 or something silly like that. I was wondering if there was a quick mod we could do that could close the idle connections. This is what seems to be causing the most problem.
Yes i know this but its not a good way to resolve the issue as it places more load on the server and does not deal with the idle connections they stay open all the time. Any other suggestions on this? I was thinking idle_timeout??