I am having 2 applications (Java and PHP). Both are sharing same DB Server. After specific time, both systems stops working due to "Too many connections". I tried so many settings (increased max_connections, maxthreadsperchild, etc) but no luck. When I restart MySQL service, applications start working. When I checked MySQL logs, I can see some connections gets opened and quit. However, after some time, I can see only connections (opened) and not quit
I checked in access logs with same timings and found that these are the same continuous requests where previously connections gets opened and quit also.
All configurations are now set to default.
Please help me to resolve this issue.
Thanks in advance.