List:General Discussion« Previous MessageNext Message »
From:Dilip Kumar Parikh Date:December 30 2009 9:26am
Subject:RE: Aborted_connects is incresing repidly
View as plain text  
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@stripped 
Pager mail:9884430998@strippedfone.in


-----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
Thread
Aborted_connects is incresing repidlyJeetendra Ranjan30 Dec
  • RE: Aborted_connects is incresing repidlyDilip Kumar Parikh30 Dec
    • Re: Aborted_connects is incresing repidlyRaMeSh30 Dec
      • RE: Aborted_connects is incresing repidlyDilip Kumar Parikh30 Dec
  • Re: Aborted_connects is incresing repidlyJeetendra Ranjan30 Dec
    • RE: Aborted_connects is incresing repidlyDilip Kumar Parikh30 Dec
  • Re: Aborted_connects is incresing repidlyTom Worster30 Dec
  • Re: Aborted_connects is incresing repidlyJim Lyons30 Dec
  • Re: Aborted_connects is incresing repidlyWalter Heck - OlinData.com30 Dec
    • Re: Aborted_connects is incresing repidlyClaudio Nanni30 Dec
      • Re: Aborted_connects is incresing repidlyClaudio Nanni30 Dec
  • Re: Aborted_connects is incresing repidlyJeetendra Ranjan31 Dec