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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
