CODEWITHSUNDEEP
mysqlcrashloadperformance
DJ_Steve
DJ_Steve

Reputation: 61

Mysql Connections topping out within seconds

i have aweird problem that has only just started happening.

i have a small cluster (one web and one db) setup and i host a rather popular group of4 -5 sites that allow users to dynamicly create their own mobile chat communitys automaticly. each site gets its own mysql db createdand populated automaticly.

this is all fine,

but in the last 24hours weird things have begun happening, previously i had the sql max_connections set to 500 and this was perfectly adaqute for the demand but now even when i set the connection to 4000+ they are all maxxed out within 5-10 minutes, and mysql processlist shows thousands of unauthenticated user connections sitting at login status,

i have gone through the sites and all their mysql configs are fine so i cant see what the issue is.

server specs below

db server:

only mysql,ssh and webmin running, no other apps installed

web server:

apache status onthe web server only shows 120ish http connections butthe sql keeps climbing

Upvotes: 1

Views: 538

Answers (2)

DJ_Steve
DJ_Steve

Reputation: 61

found the problem, for some reason mysql had decided to start trying to dodns lookups for connections, dontknow why but itseems to be sorted out now after adding skip-name-resolve to my.cnf

Upvotes: 0

Zenshai
Zenshai

Reputation: 10747

If absolutely nothing else changed, maybe someone is trying to attack your site?

See if you can find what IPs the spurious connections are coming from.

Upvotes: 1

Related Questions