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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
