On 06/12/2012 05:10 AM, Johan De Meersman wrote:
----- Original Message -----
From: "Claudio Nanni"<claudio.na...@gmail.com>
" Print out warnings such as Aborted connection... to the error log."
the dots are not telling if they comprise Aborted clients as well.
Hah, how's that for selective blindness. Totally missed that :-)
I find the MySQL error log extremely poor, as far as I know it is one
of the MySQL features (like authentication) stuck to the dawn of
MySQL times.
Very hard to debug non basic things like your issue.
From what I have experienced usually Aborted connection means wrong
credentials while Aborted clients means the client (typically PHP)
did not close the connection properly.
Yep, that's it; but indeed, since aborted clients aren't logged, then, I seem
to be in a ditch.
Do you have any chance to check if the code is closing the
connections to the mysql database?
Oh, yes, millions upon billions of lines of wonderfully obscure Java stacktraces that
reveal little more than "Lost connection to database" for every couple of
thousand lines.
Everything works fine most of the time, then randomly some queries will get
slow, and eventually the connections will drop. Rinse and repeat.
Oh well. Thanks for pointing out my reading error, I'm off to lart the devs
into profiling their code to figure out *what* causes the slowness. Guess I'll
have to set up some tcpdumps, too.
Watch out for this one, especially if the Aborted connections are all
getting charged against a single client. Per the URL below and a
misbehaving application not closing connections correctly, I've seen
this spontaneously blacklist a client IP. Only way to unblacklist after
is to run "flush-hosts" on the mysql server.
Also, didn't see a one-to-one correspondence between the global
max_connect_errors setting and Aborted_connects (from show global status
like '%abort%';), so hard to tell when you're approaching the per client
blacklist limit.
http://dev.mysql.com/doc/refman/5.0/en/blocked-host.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
