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
