List:General Discussion« Previous MessageNext Message »
From:Jeetendra Ranjan Date:December 30 2009 9:38am
Subject:Re: Aborted_connects is incresing repidly
View as plain text  
Thanks , but i want to solve this problem without shutting down the db 
server.



----- Original Message ----- 
From: "Parikh, Dilip Kumar" <dilipkumar.parikh@stripped>
To: "Jeetendra Ranjan" <jeetendra.ranjan@stripped>
Cc: <mysql@stripped>
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@stripped
> Pager mail:9884430998@stripped
>
>
> -----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