List:General Discussion« Previous MessageNext Message »
From:<vpendleton Date:February 18 2004 3:47pm
Subject:Re: Possible values in "COMMAND" for SHOW PROCESSLIST
View as plain text  
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".


> With regards,

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


> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
http://lists.mysql.com/mysql?unsub=1
Thread
Possible values in "COMMAND" for SHOW PROCESSLISTMartijn Tonies18 Feb
  • Re: Possible values in "COMMAND" for SHOW PROCESSLISTvpendleton18 Feb
  • Re: Possible values in "COMMAND" for SHOW PROCESSLISTMartijn Tonies18 Feb
    • Re: Possible values in "COMMAND" for SHOW PROCESSLISTvpendleton18 Feb
  • Re: Possible values in "COMMAND" for SHOW PROCESSLISTJeremy Zawodny18 Feb
  • Re: Possible values in "COMMAND" for SHOW PROCESSLISTMartijn Tonies18 Feb