Aborted_connects is incresing repidly

------=_NextPart_000_002A_01CA8945.3FE08D30
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

My MySQL server Aborted_connects status is showing 8692 and is rapidly =
increasing.

What are reasons and how do i decrease the same?

We are using connect() method in PHP code and have tried below command=20

mysqladmin flush-hosts=20

but still the value is same.


Thanks=20
Jeetendra Ranjan
------=_NextPart_000_002A_01CA8945.3FE08D30--

RE: Aborted_connects is incresing repidly

Jetendra,

Can u attach your my.cnf files and also your variable status (show
variable status). This is required because we need to tune some params.

Thanks,
Dilipkumar

-----Original Message-----
From: Jeetendra Ranjan [mailto:jeetendra.ranjan@sampatti.com]=20
Sent: Wednesday, December 30, 2009 11:43 AM
To: mysql@lists.mysql.com
Subject: Aborted_connects is incresing repidly

Hi,

My MySQL server Aborted_connects status is showing 8692 and is rapidly
increasing.

What are reasons and how do i decrease the same?

We are using connect() method in PHP code and have tried below command=20

mysqladmin flush-hosts=20

but still the value is same.


Thanks=20
Jeetendra Ranjan

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Aborted_connects is incresing repidly

--001636c5bbf0a33602047bee7825
Content-Type: text/plain; charset=ISO-8859-1

You can use this --max_connect_errors=999999999 to avoid this error

2009/12/30 Parikh, Dilip Kumar

> Jetendra,
>
> Can u attach your my.cnf files and also your variable status (show
> variable status). This is required because we need to tune some params.
>
> Thanks,
> Dilipkumar
>
> -----Original Message-----
> From: Jeetendra Ranjan [mailto:jeetendra.ranjan@sampatti.com]
> Sent: Wednesday, December 30, 2009 11:43 AM
> To: mysql@lists.mysql.com
> Subject: Aborted_connects is incresing repidly
>
> Hi,
>
> My MySQL server Aborted_connects status is showing 8692 and is rapidly
> increasing.
>
> What are reasons and how do i decrease the same?
>
> We are using connect() method in PHP code and have tried below command
>
> mysqladmin flush-hosts
>
> but still the value is same.
>
>
> Thanks
> Jeetendra Ranjan
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=ramesh4f@gmail.com
>
>


--
Ramesh

--001636c5bbf0a33602047bee7825--

RE: Aborted_connects is incresing repidly

VHJ5IHVzaW5nIHRoaXMgcGFyYW0gaW4gdXIgbXkuY25mIGZpbGUgYW5kIHJl c3RhcnQgdGhlIG15
c3FsIHRvIHRha2UgdGhlIG5ldyBjaGFuZ2VzLg0KDQoNCiMgVHJvdWJsZXNo b290IGZvciBNeVNR
TCBlcnJvciAyMDEzIEVycm9yIG9yIEhvc3QgYmxvY2tvdXQNCg0Kc2V0LXZh cmlhYmxlID0gY29u
bmVjdF90aW1lb3V0PTYwDQpzZXQtdmFyaWFibGUgPSBtYXhfY29ubmVjdF9l cnJvcnM9MTAwMA0K
DQoNClRoYW5rcywNCkRpbGlwa3VtYXINCkRhdGFiYXNlIEVuZ2luZWVyaW5n DQpNcGhhc2lzLCBh
biBFRFMgY29tcGFueQ0K74CoIHBob25lOiArOTEtNDQtNjYzNyAzMTY3DQrv gKsgbWFpbHRvOiBk
aWxpcGt1bWFyLnBhcmlraEBlZHMuY29tIA0KUGFnZXIgbWFpbDo5ODg0NDMw OTk4QG5tYS52b2Rh
Zm9uZS5pbg0KDQoNCi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpGcm9t OiBSYU1lU2ggW21h
aWx0bzpyYW1lc2g0ZkBnbWFpbC5jb21dIA0KU2VudDogV2VkbmVzZGF5LCBE ZWNlbWJlciAzMCwg
MjAwOSAyOjM3IFBNDQpDYzogbXlzcWxAbGlzdHMubXlzcWwuY29tDQpTdWJq ZWN0OiBSZTogQWJv
cnRlZF9jb25uZWN0cyBpcyBpbmNyZXNpbmcgcmVwaWRseQ0KDQpZb3UgY2Fu IHVzZSB0aGlzIC0t
bWF4X2Nvbm5lY3RfZXJyb3JzPTk5OTk5OTk5OSB0byBhdm9pZCB0aGlzIGVy cm9yDQoNCjIwMDkv
MTIvMzAgUGFyaWtoLCBEaWxpcCBLdW1hciA8ZGlsaXBrdW1hci5wYXJpa2hA ZWRzLmNvbT4NCg0K
PiBKZXRlbmRyYSwNCj4NCj4gQ2FuIHUgYXR0YWNoIHlvdXIgbXkuY25mIGZp bGVzIGFuZCBhbHNv
IHlvdXIgdmFyaWFibGUgc3RhdHVzIChzaG93DQo+IHZhcmlhYmxlIHN0YXR1 cykuIFRoaXMgaXMg
cmVxdWlyZWQgYmVjYXVzZSB3ZSBuZWVkIHRvIHR1bmUgc29tZSBwYXJhbXMu DQo+DQo+IFRoYW5r
cywNCj4gRGlsaXBrdW1hcg0KPg0KPiAtLS0tLU9yaWdpbmFsIE1lc3NhZ2Ut LS0tLQ0KPiBGcm9t
OiBKZWV0ZW5kcmEgUmFuamFuIFttYWlsdG86amVldGVuZHJhLnJhbmphbkBz YW1wYXR0aS5jb21d
DQo+IFNlbnQ6IFdlZG5lc2RheSwgRGVjZW1iZXIgMzAsIDIwMDkgMTE6NDMg QU0NCj4gVG86IG15
c3FsQGxpc3RzLm15c3FsLmNvbQ0KPiBTdWJqZWN0OiBBYm9ydGVkX2Nvbm5l Y3RzIGlzIGluY3Jl
c2luZyByZXBpZGx5DQo+DQo+IEhpLA0KPg0KPiBNeSBNeVNRTCBzZXJ2ZXIg QWJvcnRlZF9jb25u
ZWN0cyBzdGF0dXMgaXMgc2hvd2luZyA4NjkyIGFuZCBpcyByYXBpZGx5DQo+ IGluY3JlYXNpbmcu
DQo+DQo+IFdoYXQgYXJlIHJlYXNvbnMgYW5kIGhvdyBkbyBpIGRlY3JlYXNl IHRoZSBzYW1lPw0K
Pg0KPiBXZSBhcmUgdXNpbmcgY29ubmVjdCgpIG1ldGhvZCBpbiBQSFAgY29k ZSBhbmQgaGF2ZSB0
cmllZCBiZWxvdyBjb21tYW5kDQo+DQo+IG15c3FsYWRtaW4gZmx1c2gtaG9z dHMNCj4NCj4gYnV0
IHN0aWxsIHRoZSB2YWx1ZSBpcyBzYW1lLg0KPg0KPg0KPiBUaGFua3MNCj4g SmVldGVuZHJhIFJh
bmphbg0KPg0KPiAtLQ0KPiBNeVNRTCBHZW5lcmFsIE1haWxpbmcgTGlzdA0K PiBGb3IgbGlzdCBh
cmNoaXZlczogaHR0cDovL2xpc3RzLm15c3FsLmNvbS9teXNxbA0KPiBUbyB1 bnN1YnNjcmliZTog
ICAgaHR0cDovL2xpc3RzLm15c3FsLmNvbS9teXNxbD91bnN1Yj1yYW1lc2g0 ZkBnbWFpbC5jb20N
Cj4NCj4NCg0KDQotLSANClJhbWVzaA0K

Re: Aborted_connects is incresing repidly

Thanks , but i want to solve this problem without shutting down the db
server.



----- Original Message -----
From: "Parikh, Dilip Kumar"
To: "Jeetendra Ranjan"
Cc:
Sent: Wednesday, December 30, 2009 2:56 PM
Subject: RE: Aborted_connects is incresing repidly


> Try using this param in ur my.cnf file and restart the mysql to take the
> new changes.
>
>
> # Troubleshoot for MySQL error 2013 Error or Host blockout
>
> set-variable = connect_timeout=60
> set-variable = max_connect_errors=1000
>
>
> Thanks,
> Dilipkumar
> Database Engineering
> Mphasis, an EDS company
>  phone: +91-44-6637 3167
>  mailto: dilipkumar.parikh@eds.com
> Pager mail:9884430998@nma.vodafone.in
>
>
> -----Original Message-----
> From: RaMeSh [mailto:ramesh4f@gmail.com]
> Sent: Wednesday, December 30, 2009 2:37 PM
> Cc: mysql@lists.mysql.com
> Subject: Re: Aborted_connects is incresing repidly
>
> You can use this --max_connect_errors=999999999 to avoid this error
>
> 2009/12/30 Parikh, Dilip Kumar
>
>> Jetendra,
>>
>> Can u attach your my.cnf files and also your variable status (show
>> variable status). This is required because we need to tune some params.
>>
>> Thanks,
>> Dilipkumar
>>
>> -----Original Message-----
>> From: Jeetendra Ranjan [mailto:jeetendra.ranjan@sampatti.com]
>> Sent: Wednesday, December 30, 2009 11:43 AM
>> To: mysql@lists.mysql.com
>> Subject: Aborted_connects is incresing repidly
>>
>> Hi,
>>
>> My MySQL server Aborted_connects status is showing 8692 and is rapidly
>> increasing.
>>
>> What are reasons and how do i decrease the same?
>>
>> We are using connect() method in PHP code and have tried below command
>>
>> mysqladmin flush-hosts
>>
>> but still the value is same.
>>
>>
>> Thanks
>> Jeetendra Ranjan
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=ramesh4f@gmail.com
>>
>>
>
>
> --
> Ramesh


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Aborted_connects is incresing repidly

U2V0IHRoZW0gZ2xvYmFsbHkuDQoNClRoYW5rcywNCkRpbGlwa3VtYXINCkRh dGFiYXNlIEVuZ2lu
ZWVyaW5nDQpQYWdlciBtYWlsOjk4ODQ0MzA5OThAbm1hLnZvZGFmb25lLmlu DQoNCg0KLS0tLS1P
cmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206IEplZXRlbmRyYSBSYW5qYW4g W21haWx0bzpqZWV0
ZW5kcmEucmFuamFuQHNhbXBhdHRpLmNvbV0gDQpTZW50OiBXZWRuZXNkYXks IERlY2VtYmVyIDMw
LCAyMDA5IDM6MDggUE0NClRvOiBQYXJpa2gsIERpbGlwIEt1bWFyDQpDYzog bXlzcWxAbGlzdHMu
bXlzcWwuY29tDQpTdWJqZWN0OiBSZTogQWJvcnRlZF9jb25uZWN0cyBpcyBp bmNyZXNpbmcgcmVw
aWRseQ0KDQpUaGFua3MgLCBidXQgaSB3YW50IHRvIHNvbHZlIHRoaXMgcHJv YmxlbSB3aXRob3V0
IHNodXR0aW5nIGRvd24gdGhlIGRiIA0Kc2VydmVyLg0KDQoNCg0KLS0tLS0g T3JpZ2luYWwgTWVz
c2FnZSAtLS0tLSANCkZyb206ICJQYXJpa2gsIERpbGlwIEt1bWFyIiA8ZGls aXBrdW1hci5wYXJp
a2hAZWRzLmNvbT4NClRvOiAiSmVldGVuZHJhIFJhbmphbiIgPGplZXRlbmRy YS5yYW5qYW5Ac2Ft
cGF0dGkuY29tPg0KQ2M6IDxteXNxbEBsaXN0cy5teXNxbC5jb20+DQpTZW50 OiBXZWRuZXNkYXks
IERlY2VtYmVyIDMwLCAyMDA5IDI6NTYgUE0NClN1YmplY3Q6IFJFOiBBYm9y dGVkX2Nvbm5lY3Rz
IGlzIGluY3Jlc2luZyByZXBpZGx5DQoNCg0KPiBUcnkgdXNpbmcgdGhpcyBw YXJhbSBpbiB1ciBt
eS5jbmYgZmlsZSBhbmQgcmVzdGFydCB0aGUgbXlzcWwgdG8gdGFrZSB0aGUg DQo+IG5ldyBjaGFu
Z2VzLg0KPg0KPg0KPiAjIFRyb3VibGVzaG9vdCBmb3IgTXlTUUwgZXJyb3Ig MjAxMyBFcnJvciBv
ciBIb3N0IGJsb2Nrb3V0DQo+DQo+IHNldC12YXJpYWJsZSA9IGNvbm5lY3Rf dGltZW91dD02MA0K
PiBzZXQtdmFyaWFibGUgPSBtYXhfY29ubmVjdF9lcnJvcnM9MTAwMA0KPg0K Pg0KPiBUaGFua3Ms
DQo+IERpbGlwa3VtYXINCj4gRGF0YWJhc2UgRW5naW5lZXJpbmcNCj4gTXBo YXNpcywgYW4gRURT
IGNvbXBhbnkNCj4g74CoIHBob25lOiArOTEtNDQtNjYzNyAzMTY3DQo+IO+A qyBtYWlsdG86IGRp
bGlwa3VtYXIucGFyaWtoQGVkcy5jb20NCj4gUGFnZXIgbWFpbDo5ODg0NDMw OTk4QG5tYS52b2Rh
Zm9uZS5pbg0KPg0KPg0KPiAtLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0K PiBGcm9tOiBSYU1l
U2ggW21haWx0bzpyYW1lc2g0ZkBnbWFpbC5jb21dDQo+IFNlbnQ6IFdlZG5l c2RheSwgRGVjZW1i
ZXIgMzAsIDIwMDkgMjozNyBQTQ0KPiBDYzogbXlzcWxAbGlzdHMubXlzcWwu Y29tDQo+IFN1Ympl
Y3Q6IFJlOiBBYm9ydGVkX2Nvbm5lY3RzIGlzIGluY3Jlc2luZyByZXBpZGx5 DQo+DQo+IFlvdSBj
YW4gdXNlIHRoaXMgLS1tYXhfY29ubmVjdF9lcnJvcnM9OTk5OTk5OTk5IHRv IGF2b2lkIHRoaXMg
ZXJyb3INCj4NCj4gMjAwOS8xMi8zMCBQYXJpa2gsIERpbGlwIEt1bWFyIDxk aWxpcGt1bWFyLnBh
cmlraEBlZHMuY29tPg0KPg0KPj4gSmV0ZW5kcmEsDQo+Pg0KPj4gQ2FuIHUg YXR0YWNoIHlvdXIg
bXkuY25mIGZpbGVzIGFuZCBhbHNvIHlvdXIgdmFyaWFibGUgc3RhdHVzIChz aG93DQo+PiB2YXJp
YWJsZSBzdGF0dXMpLiBUaGlzIGlzIHJlcXVpcmVkIGJlY2F1c2Ugd2UgbmVl ZCB0byB0dW5lIHNv
bWUgcGFyYW1zLg0KPj4NCj4+IFRoYW5rcywNCj4+IERpbGlwa3VtYXINCj4+ DQo+PiAtLS0tLU9y
aWdpbmFsIE1lc3NhZ2UtLS0tLQ0KPj4gRnJvbTogSmVldGVuZHJhIFJhbmph biBbbWFpbHRvOmpl
ZXRlbmRyYS5yYW5qYW5Ac2FtcGF0dGkuY29tXQ0KPj4gU2VudDogV2VkbmVz ZGF5LCBEZWNlbWJl
ciAzMCwgMjAwOSAxMTo0MyBBTQ0KPj4gVG86IG15c3FsQGxpc3RzLm15c3Fs LmNvbQ0KPj4gU3Vi
amVjdDogQWJvcnRlZF9jb25uZWN0cyBpcyBpbmNyZXNpbmcgcmVwaWRseQ0K Pj4NCj4+IEhpLA0K
Pj4NCj4+IE15IE15U1FMIHNlcnZlciBBYm9ydGVkX2Nvbm5lY3RzIHN0YXR1 cyBpcyBzaG93aW5n
IDg2OTIgYW5kIGlzIHJhcGlkbHkNCj4+IGluY3JlYXNpbmcuDQo+Pg0KPj4g V2hhdCBhcmUgcmVh
c29ucyBhbmQgaG93IGRvIGkgZGVjcmVhc2UgdGhlIHNhbWU/DQo+Pg0KPj4g V2UgYXJlIHVzaW5n
IGNvbm5lY3QoKSBtZXRob2QgaW4gUEhQIGNvZGUgYW5kIGhhdmUgdHJpZWQg YmVsb3cgY29tbWFu
ZA0KPj4NCj4+IG15c3FsYWRtaW4gZmx1c2gtaG9zdHMNCj4+DQo+PiBidXQg c3RpbGwgdGhlIHZh
bHVlIGlzIHNhbWUuDQo+Pg0KPj4NCj4+IFRoYW5rcw0KPj4gSmVldGVuZHJh IFJhbmphbg0KPj4N
Cj4+IC0tDQo+PiBNeVNRTCBHZW5lcmFsIE1haWxpbmcgTGlzdA0KPj4gRm9y IGxpc3QgYXJjaGl2
ZXM6IGh0dHA6Ly9saXN0cy5teXNxbC5jb20vbXlzcWwNCj4+IFRvIHVuc3Vi c2NyaWJlOiAgICBo
dHRwOi8vbGlzdHMubXlzcWwuY29tL215c3FsP3Vuc3ViPXJhbWVzaDRmQGdt YWlsLmNvbQ0KPj4N
Cj4+DQo+DQo+DQo+IC0tIA0KPiBSYW1lc2ggDQoNCg==

Re: Aborted_connects is incresing repidly

On 12/30/09 1:13 AM, "Jeetendra Ranjan"
wrote:

> Hi,
>
> My MySQL server Aborted_connects status is showing 8692 and is rapidly
> increasing.
>
> What are reasons and how do i decrease the same?
>
> We are using connect() method in PHP code and have tried below command
>
> mysqladmin flush-hosts
>
> but still the value is same.


have you recently upgraded to php 5.3?

if so, the default value for default_socket_timeout changed. lots of people
experienced mysql connections aborting on long queries. i set it to -1, i.e.
doesn't time out.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Aborted_connects is incresing repidly

--0016e6d7e32d4944d5047bf6c877
Content-Type: text/plain; charset=ISO-8859-1

This error may be caused by applications that don't close their connections
when they finish. The session stays open until the timeout. If this
becomes a problem, look at the various applications running on your system.
You might be able to program them better, to either close their connections
or reuse a connection.

If you run "show processlist" you will probably find a lot of processes in
"Sleep" state. You can write a script to run regularly that will kill any
process that is sleeping longer than a certain minimum amount of time. That
way you won't hit your max connections and prevent others from logging in.
I did this recently when a rogue process was opening sessions and leaving
them open. I ran the script, selected those processes run by that user
against that database that were in "Sleep" state, and killed them dead.
This fixed the problem untili we were able to track down the rogue processes
and fix it.

Jim

On Wed, Dec 30, 2009 at 12:13 AM, Jeetendra Ranjan <
jeetendra.ranjan@sampatti.com> wrote:

> Hi,
>
> My MySQL server Aborted_connects status is showing 8692 and is rapidly
> increasing.
>
> What are reasons and how do i decrease the same?
>
> We are using connect() method in PHP code and have tried below command
>
> mysqladmin flush-hosts
>
> but still the value is same.
>
>
> Thanks
> Jeetendra Ranjan




--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com

--0016e6d7e32d4944d5047bf6c877--

Re: Aborted_connects is incresing repidly

Random shot in the dark: I've seen this happen with some monitoring
tools that just check to see if the database is up.

Walter

On Wed, Dec 30, 2009 at 17:13, Jeetendra Ranjan
wrote:
> Hi,
>
> My MySQL server Aborted_connects status is showing 8692 and is rapidly increasing.
>
> What are reasons and how do i decrease the same?
>
> We are using connect() method in PHP code and have tried below command
>
> mysqladmin flush-hosts
>
> but still the value is same.
>
>
> Thanks
> Jeetendra Ranjan

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Aborted_connects is incresing repidly

--001636457b269917c3047bf794c0
Content-Type: text/plain; charset=ISO-8859-1

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"
wrote:

Random shot in the dark: I've seen this happen with some monitoring
tools that just check to see if the database is up.

Walter

On Wed, Dec 30, 2009 at 17:13, Jeetendra Ranjan

wrote:

> 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...

--001636457b269917c3047bf794c0--

Re: Aborted_connects is incresing repidly

--001485f771c86a6917047bf79d93
Content-Type: text/plain; charset=ISO-8859-1

@Walter
By the way your guess is the most likely, good shot!

Claudio

On 30 dec 2009 20:59, "Claudio Nanni" 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"
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...

--001485f771c86a6917047bf79d93--

Re: Aborted_connects is incresing repidly

------=_NextPart_000_0052_01CA8A0D.F2DB59B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,=20
The server where i faced this problem was master server(Replication) but =
it was not in use.
I simply comment the server-id=3D1 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 -----=20
From: Claudio Nanni=20
To: Walter Heck - OlinData.com=20
Cc: mysql@lists.mysql.com ; Jeetendra Ranjan=20
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" 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.=20
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" =
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...



------=_NextPart_000_0052_01CA8A0D.F2DB59B0--