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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org