I have a server system running on Mac OS X 10.4 (Darwin Kernel Version 8.10.1). This server is used mainly as a Bugzilla Server, but there are some other web-based services running (Testlink, TikiWiki).
The Bugzilla database has about 60000 bugs in it, and there are about 300 active users on the system.
Bugzilla is on version 3.0, running on Perl 5.8.6, Apache 1.3.33 with mySQL 5.0.38
From time to time, we have serious trouble that Bugzilla throws a database error:
Software error: Can't connect to the database. Error: Too many connections
I already have several leads to possible solutions to this problem, but I wanted to bring up a more general question how you would debug these types of problems?
Right now we have set up the following to monitor the mySQL database:
- A cron job which dumps the full mysql processlist every 5 minutes
- Enabled log-slow-queries in my.cnf to log queries that take longer than 15 seconds
We just started gathering this data to see if we can find a reason for the "Too many connections" problem.
Are there any other things you can think of to monitor a mySQL database and to help diagnose the root cause of the problem?