-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I was seeing all of the connections from am-macs[1-8]. I will try to dig up the logs. When I bumped the max connection limit, I just got another 100 connections from the same machines to COBALT. Ken Anthony Jazokas wrote:
Ken,
My access to the MySQL COBALT database shouldn't be more that a handful of connections at a time, not in the hundreds. I am defining a connection as a (in my case) PERL handle to the database but many read/write/updates. Note that there are other people using this database also.
Can you send me some log information so I can track down which code I am running is causing problems?
Anthony
Kenneth Raffenetti wrote: Whatever was happening was out of control. It was killing a number of our websites and was eating up all the connections I needed to get in there and revoke privileges. I had to drop the database. I can provide last nights dump, but I don't think we can run on our database server in this state.
Ken
Kenneth Raffenetti wrote:
Please try to limit the number of connections you are making to the MySQL server. I have bumped the maximum number from 150 to 250. How many is your code going to make total?
Ken
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAkn5xhsACgkQvRJB9CBtvwjBwwCglFPcmnXKPWK1O82l9AHQT2EU 34YAoLSwL6s0hjNaZINddJJQ6RfW9wUX =a6nv -----END PGP SIGNATURE-----