RE: Aborted_connects is incresing repidly

[Dilip Kumar Parikh]

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: [phone]
 mailto: dilipkumar.parikh@stripped 
Pager mail:[e-mail]


-----Original Message-----
From: RaMeSh [mailto:ramesh4f@stripped] 
Sent: Wednesday, December 30, 2009 2:37 PM
Cc: mysql@stripped
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 <dilipkumar.parikh@stripped>

> 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@stripped]
> Sent: Wednesday, December 30, 2009 11:43 AM
> To: mysql@stripped
> 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=1
>
>


-- 
Ramesh