Set them globally. Thanks, Dilipkumar Database Engineering Pager mail:9884430...@nma.vodafone.in
-----Original Message----- From: Jeetendra Ranjan [mailto:jeetendra.ran...@sampatti.com] Sent: Wednesday, December 30, 2009 3:08 PM To: Parikh, Dilip Kumar Cc: mysql@lists.mysql.com Subject: Re: Aborted_connects is incresing repidly Thanks , but i want to solve this problem without shutting down the db server. ----- Original Message ----- From: "Parikh, Dilip Kumar" <dilipkumar.par...@eds.com> To: "Jeetendra Ranjan" <jeetendra.ran...@sampatti.com> Cc: <mysql@lists.mysql.com> 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.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