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.par...@eds.com 
Pager mail:9884430...@nma.vodafone.in


-----Original Message-----
From: RaMeSh [mailto:rames...@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 <dilipkumar.par...@eds.com>

> 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.ran...@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=rames...@gmail.com
>
>


-- 
Ramesh

Reply via email to