My confusion, I thought that was what you were asking for. >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 2/18/04, 10:01:24 AM, Martijn Tonies <[EMAIL PROTECTED]> wrote regarding Re: Possible values in "COMMAND" for SHOW PROCESSLIST: > 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]