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