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
