MySQL: Too many connections (1040)

[josh]

Hi - we are using the standard bundled MySQL package for our supervisor but I'm seeing lately we have the following error over and over:

Too many connections (1040)

So I wonder if it's as simple as finding/editing the my.cnf file for the bundled MySQL and restarting the MySQL service?

Any help would be appreciated,
Josh

[josh]

i've added max_connections=1024 in our my.ini (c:\windows) but it's not seeming to fix the logfile messages...

[eric]

How many Supervisor threads do you have?

[josh]

Ah, yes, I forgot to post back, but I had that at 256 and changed back to 128 and seems to have resolved it. Still curious why I'd cause issues all of a sudden, I changed that about two weeks into deployment...

Also, was 256 a bad choice? Initially I had changed it thinking it had something to do with amount of users using the Qube! client software, some of them were getting time-outs randomly...

Thanks for the reply,
Josh

[anthony]

Hey Josh,

    Are you using the windows or linux version of the supervisor?  There is a known issue on windows where the sockets are not immediatly closed, so you may be the symptoms you are describing with lots of traffic hitting your supe.

    Anthony

[josh]

Ah, we are running the supe on a windows platform, that might explain it. I thought it was odd that changing it from 128 > 265 worked considering we only have about 50 Qube clients.

Josh