List:General Discussion« Previous MessageNext Message »
From:Jim Lyons Date:December 30 2009 7:02pm
Subject:Re: Aborted_connects is incresing repidly
View as plain text  
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.ranjan@stripped> 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

Thread
Aborted_connects is incresing repidlyJeetendra Ranjan30 Dec
  • RE: Aborted_connects is incresing repidlyDilip Kumar Parikh30 Dec
    • Re: Aborted_connects is incresing repidlyRaMeSh30 Dec
      • RE: Aborted_connects is incresing repidlyDilip Kumar Parikh30 Dec
  • Re: Aborted_connects is incresing repidlyJeetendra Ranjan30 Dec
    • RE: Aborted_connects is incresing repidlyDilip Kumar Parikh30 Dec
  • Re: Aborted_connects is incresing repidlyTom Worster30 Dec
  • Re: Aborted_connects is incresing repidlyJim Lyons30 Dec
  • Re: Aborted_connects is incresing repidlyWalter Heck - OlinData.com30 Dec
    • Re: Aborted_connects is incresing repidlyClaudio Nanni30 Dec
      • Re: Aborted_connects is incresing repidlyClaudio Nanni30 Dec
  • Re: Aborted_connects is incresing repidlyJeetendra Ranjan31 Dec