[prev in list] [next in list] [prev in thread] [next in thread] 

List:       msql-mysql-modules
Subject:    Re: Tons of Sleep processes
From:       "Jeremy D. Zawodny" <jzawodn () yahoo-inc ! com>
Date:       2001-02-01 3:19:18
[Download RAW message or body]

On Thu, Feb 01, 2001 at 12:23:43AM +0200, Eran Boudjnah wrote:
> Hi,
> 
> I'm running mytop 0.5 to check the status of my MySQL on my Redhat
> box, and I notice many Sleep commands are being executed. Does
> anybody know what those are and how do I avoid them?

They're idle MySQL threads. It means that a client is [probably]
connected but not executing a query at that exact moment.

It's not necessarily a BAD thing--unless you have way to many of
them. It's also bad if your applications are needlessly keeping open
database connections.

Jeremy
-- 
Jeremy D. Zawodny, <jzawodn@yahoo-inc.com>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878    Fax: (408) 530-5454
Cell: (408) 439-9951

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread998@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]