From: Martijn Tonies
Date: February 18 2004 4:01pm
Subject: Re: Possible values in "COMMAND" for SHOW PROCESSLIST
List-Archive: http://lists.mysql.com/mysql/159929
Message-Id: <0f5a01c3f638$756c7730$0e02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi,

Are you sure about this? According to
http://www.mysql.com/doc/en/SHOW_PROCESSLIST.html
these are the values of "State"

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com


> Checking table
> Closing tables
> connect out
> Copying to tmp table on disk
> Creating tmp table
> Deleting tmp table
> Deleting from main table
> Deleting from reference tables
> Flushing tables
> Killed
> Sending data
> Sorting for group
> Sorting for order
> Opening tables
> Removing duplicates
> Reopen table
> Repair by sorting
> Repair with keycache
> Searching rows for update
> Sleeping
> System lock
> Upgrading lock
> Updating
> User lock
> Waiting for tables
> Waiting for handler insert
> ...
> These are ones that I know of.
>
> >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
>
> On 2/18/04, 9:26:21 AM, Martijn Tonies <m.tonies@stripped> wrote
> regarding Possible values in "COMMAND" for SHOW PROCESSLIST:
>
>
> > Hi,
>
> > Does anyone know what the possible values for column
> > "Command" are when doing a SHOW PROCESSLIST?
>
> > All I'm getting so far, is "Query", "Killed" and "Sleep".