Re: Possible values in "COMMAND" for SHOW PROCESSLIST

2004-02-18 Thread Martijn Tonies
Hi Jeremy, > On Wed, Feb 18, 2004 at 04:26:21PM +0100, Martijn Tonies wrote: > > Hi, > > > > Does anyone know what the possible values for column > > "Command" are when doing a SHOW PROCESSLIST? > > A table in Chapter 1 of High Performance MySQL[*] Thanks! With regards, Martijn Tonies Database

Re: Possible values in "COMMAND" for SHOW PROCESSLIST

2004-02-18 Thread Jeremy Zawodny
On Wed, Feb 18, 2004 at 04:26:21PM +0100, Martijn Tonies wrote: > Hi, > > Does anyone know what the possible values for column > "Command" are when doing a SHOW PROCESSLIST? A table in Chapter 1 of High Performance MySQL[*] Binlog Dump Change user Connect Connect Out Create DB Debug Delayed_inse

Re: Possible values in "COMMAND" for SHOW PROCESSLIST

2004-02-18 Thread vpendleton
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

Re: Possible values in "COMMAND" for SHOW PROCESSLIST

2004-02-18 Thread Martijn Tonies
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 tab

Re: Possible values in "COMMAND" for SHOW PROCESSLIST

2004-02-18 Thread vpendleton
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