Hi,
The server where i faced this problem was master server(Replication) but it was not in
use.
I simply comment the server-id=1 in my.cnf and run the command "revoke replication slave
on".
And now i see the increasing aborted_connects stopped.
anyway, thanks to all for your support
Regards
Jeetendra Ranjan
----- Original Message -----
From: Claudio Nanni
To: Walter Heck - OlinData.com
Cc: mysql@stripped ; Jeetendra Ranjan
Sent: Thursday, December 31, 2009 1:32 AM
Subject: Re: Aborted_connects is incresing repidly
@Walter
By the way your guess is the most likely, good shot!
Claudio
On 30 dec 2009 20:59, "Claudio Nanni" <claudio.nanni@stripped> wrote:
Waltet, I think you are not the only one shooting in the dark, in this case reading the
manual can really help.
aborted_connects is increased by a failed attempt to connect to MySQL (wrong password?)
but NOT by a timed-out client.
Could be a cron job setup with some credentials that were changed without updating it,
or other similar things. There is a very bad habit of not setting the root password (or
to put it in the my.cnf) so sometimes mysql client is considered just a bash command and
included as it in scripts. As long as you dont experience problems the simple increase of
the value is not a critical issue.
Check the logs of the application(s) ,if any, to see if some part of it is actually
affected.
Cheers
Claudio
> > On 30 dec 2009 20:31, "Walter Heck - OlinData.com"
<lists@stripped> wrote: > > Random shot ...
> Hi, > > My MySQL server Aborted_connects status is showing 8692 and is
rapidly increasing. > > Wha...
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To
unsubscribe: ht...
