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@lists.mysql.com ; 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.na...@gmail.com> 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" <li...@olindata.com>
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...
