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, 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
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=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, 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
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=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, 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Aborted_connects is incresing repidly
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=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, 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
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 mysqladmin flush-hosts but still the value is same. have you recently upgraded to php 5.3? if so, the default value for default_socket_timeout changed. lots of people experienced mysql connections aborting on long queries. i set it to -1, i.e. doesn't time out. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 or reuse a connection. If you run show processlist you will probably find a lot of processes in Sleep state. You can write a script to run regularly that will kill any process that is sleeping longer than a certain minimum amount of time. That way you won't hit your max connections and prevent others from logging in. I did this recently when a rogue process was opening sessions and leaving them open. I ran the script, selected those processes run by that user against that database that were in Sleep state, and killed them dead. This fixed the problem untili we were able to track down the rogue processes and fix it. Jim On Wed, Dec 30, 2009 at 12: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 mysqladmin flush-hosts but still the value is same. Thanks Jeetendra Ranjan -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
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 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=arch...@jab.org
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 without updating it, or other similar things. There is a very bad habit of not setting the root password (or to put it in the my.cnf) so sometimes mysql client is considered just a bash command and included as it in scripts. As long as you dont experience problems the simple increase of the value is not a critical issue. Check the logs of the application(s) ,if any, to see if some part of it is actually affected. Cheers Claudio On 30 dec 2009 20:31, Walter Heck - OlinData.com li...@olindata.com wrote: 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 increasing. Wha... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: ht...
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 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 without updating it, or other similar things. There is a very bad habit of not setting the root password (or to put it in the my.cnf) so sometimes mysql client is considered just a bash command and included as it in scripts. As long as you dont experience problems the simple increase of the value is not a critical issue. Check the logs of the application(s) ,if any, to see if some part of it is actually affected. Cheers Claudio On 30 dec 2009 20:31, Walter Heck - OlinData.com li...@olindata.com wrote: Random shot ... Hi, My MySQL server Aborted_connects status is showing 8692 and is rapidly increasing. Wha... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: ht...
Re: Aborted_connects is incresing repidly
Hi, The server where i faced this problem was master server(Replication) but it was not in use. I simply comment the server-id=1 in my.cnf and run the command revoke replication slave on. And now i see the increasing aborted_connects stopped. anyway, thanks to all for your support Regards 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 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 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 without updating it, or other similar things. There is a very bad habit of not setting the root password (or to put it in the my.cnf) so sometimes mysql client is considered just a bash command and included as it in scripts. As long as you dont experience problems the simple increase of the value is not a critical issue. Check the logs of the application(s) ,if any, to see if some part of it is actually affected. Cheers Claudio On 30 dec 2009 20:31, Walter Heck - OlinData.com li...@olindata.com wrote: Random shot ... Hi, My MySQL server Aborted_connects status is showing 8692 and is rapidly increasing. Wha... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: ht...
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 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=arch...@jab.org