Set them globally. Thanks, Dilipkumar Database Engineering Pager mail:[email protected]
-----Original Message----- From: Jeetendra Ranjan [mailto:[email protected]] Sent: Wednesday, December 30, 2009 3:08 PM To: Parikh, Dilip Kumar Cc: [email protected] 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" <[email protected]> To: "Jeetendra Ranjan" <[email protected]> Cc: <[email protected]> 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: [email protected] > Pager mail:[email protected] > > > -----Original Message----- > From: RaMeSh [mailto:[email protected]] > Sent: Wednesday, December 30, 2009 2:37 PM > Cc: [email protected] > 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 <[email protected]> > >> 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:[email protected]] >> Sent: Wednesday, December 30, 2009 11:43 AM >> To: [email protected] >> 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/[email protected] >> >> > > > -- > Ramesh
