FYI: MySQL default max_connections

[Bas A . Schulte]

Hi all,

just recovering from a major spike on our MySQL server and thought I'd share something *I* didn't know...

We got a db box with MySQL on it and 2 (mod_perl) webservers on separate boxes, the mod_perl servers have MaxClients set to 160 for one machine and 40 for the other. Now we had a little spike this evening and what happened was this:

DBD::mysql::st execute failed: Too many connections at /opt/ttgp/prod/ttgp/lib/TTGP/ObjectServer.pm line 245.

After some digging around it appears that MySQL default max. number of connections is 100, no matter how much RAM you stuck in your server! So even though I had no real problems with my webservers, MySQL didn't allow new connections.

I added this to /etc/my.cnf (and restarted mysqld):

[mysqld]
...
set-variable = max_connections=300
...

Now I can have my 200 connections again and actually use that precious RAM in my db server ;)

Just thought I'd mention it if you ever get caught with this problem.

Regards,

Bas.