Re: Aborted_connects is incresing repidly

You can use this --max_connect_errors=9 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,

RE: Aborted_connects is incresing repidly

: +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

Re: Aborted_connects is incresing repidly

: 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

RE: Aborted_connects is incresing repidly

, 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

Re: Aborted_connects is incresing repidly

On 12/30/09 1:13 AM, Jeetendra Ranjan jeetendra.ran...@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

Re: Aborted_connects is incresing repidly

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

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 jeetendra.ran...@sampatti.com wrote: Hi, My MySQL server Aborted_connects status is showing 8692 and is rapidly

Re: Aborted_connects is incresing repidly

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

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 claudio.na...@gmail.com 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

Re: Aborted_connects is incresing repidly

Jeetendra Ranjan - Original Message - From: Claudio Nanni To: Walter Heck - OlinData.com Cc: mysql@lists.mysql.com ; Jeetendra Ranjan Sent: Thursday, December 31, 2009 1:32 AM Subject: Re: Aborted_connects is incresing repidly @Walter By the way your guess is the most

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.ran...@sampatti.com] Sent: Wednesday, December 30, 2009