List:General Discussion« Previous MessageNext Message »
From:<vpendleton Date:February 18 2004 4:21pm
Subject:Re: Possible values in "COMMAND" for SHOW PROCESSLIST
View as plain text  
My confusion, I thought that was what you were asking for.

>>>>>>>>>>>>>>>>>> Original Message
> <<<<<<<<<<<<<<<<<<

On 2/18/04, 10:01:24 AM, Martijn Tonies <m.tonies@stripped> 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 <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".


> --
> 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