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.
On Wed, Dec 30, 2009 at 12:13 AM, Jeetendra Ranjan <
> My MySQL server Aborted_connects status is showing 8692 and is rapidly
> 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.
> Jeetendra Ranjan
Web developer / Database administrator