How to find root cause for "too many connections" error in MySQL/PHP

Posted by Nir on Stack Overflow See other posts from Stack Overflow or by Nir
Published on 2010-04-15T09:33:09Z Indexed on 2010/04/22 10:03 UTC
Read the original article Hit count: 188

Filed under:
|

I'm running a web service which runs algorithms that serve millions of calls daily and run some background processing as well. Every now and than I see "Too many connections" error in attempts to connect to the MySQL box" for a few seconds. However this is not necessarily attributed to high traffic times or anything I can put my finger on.

I want to find the bottleneck causing it. Other than in the specific times this happens the server isn't too loaded in terms of CPU and Memory, and has 2-3 connections (threads) open and everything works smoothly. (I use Zabbix for monitoring)

Any creative ideas on how to trace it?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about Performance