List:Commits« Previous MessageNext Message »
From:stefan Date:January 5 2006 10:47pm
Subject:svn commit - mysqldoc@docsrva: r696 - in trunk: refman-4.1 refman-5.0 refman-5.1
View as plain text  
Author: shinz
Date: 2006-01-05 23:47:03 +0100 (Thu, 05 Jan 2006)
New Revision: 696

Log:
Added more details to show-processlist section (Bug #15489)

Modified:
   trunk/refman-4.1/sql-syntax.xml
   trunk/refman-5.0/sql-syntax.xml
   trunk/refman-5.1/sql-syntax.xml

Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml	2006-01-05 20:47:18 UTC (rev 695)
+++ trunk/refman-4.1/sql-syntax.xml	2006-01-05 22:47:03 UTC (rev 696)
@@ -14290,14 +14290,6 @@
         <remark role="help-description-end"/>
 
         <para>
-          Starting from MySQL 4.0.12, the statement reports the hostname
-          for TCP/IP connections in
-          <literal><replaceable>host_name</replaceable>:<replaceable>client_port</replaceable></literal>
-          format to make it easier to determine which client is doing
-          what.
-        </para>
-
-        <para>
           This statement is very useful if you get the <quote>too many
           connections</quote> error message and want to find out what is
           going on. MySQL reserves one extra connection to be used by
@@ -14306,6 +14298,294 @@
           and check the system (assuming that you are not giving this
           privilege to all your users).
         </para>
+        
+        <para>
+          The output of <literal>SHOW PROCESSLIST</literal> may look like this:
+          <programlisting>
+mysql> SHOW FULL PROCESSLIST\G
+*************************** 1. row ***************************
+Id: 1
+User: system user
+Host:
+db: NULL
+Command: Connect
+Time: 1030455
+State: Waiting for master to send event
+Info: NULL
+*************************** 2. row ***************************
+Id: 2
+User: system user
+Host:
+db: NULL
+Command: Connect
+Time: 1004
+State: Has read all relay log; waiting for the slave I/O thread to update it
+Info: NULL
+*************************** 3. row ***************************
+Id: 3112
+User: replikator
+Host: artemis:2204
+db: NULL
+Command: Binlog Dump
+Time: 2144
+State: Has sent all binlog to slave; waiting for binlog to be updated
+Info: NULL
+*************************** 4. row ***************************
+Id: 3113
+User: replikator
+Host: iconnect2:45781
+db: NULL
+Command: Binlog Dump
+Time: 2086
+State: Has sent all binlog to slave; waiting for binlog to be updated
+Info: NULL
+*************************** 5. row ***************************
+Id: 3123
+User: stefan
+Host: localhost
+db: apollon
+Command: Query
+Time: 0
+State: NULL
+Info: SHOW FULL PROCESSLIST
+5 rows in set (0.00 sec)
+          </programlisting>
+          The columns have the following meaning:
+          <itemizedlist>
+            <listitem>
+              <para>
+                <literal>Id</literal>: The connection identifier
+              </para>
+            </listitem>
+            <listitem>
+              <para>
+                <literal>User</literal>: The MySQL user who is issuing the statement
+              </para>
+              <para>
+                If the user is <literal>system user</literal>, 
+                it can be either of these:
+                <itemizedlist>
+                  <listitem>
+                    <para>
+                      <literal>SYSTEM_THREAD_DELAYED_INSERT</literal>
+                    </para>
+                  </listitem>
+                  <listitem>
+                    <para>
+                      <literal>SYSTEM_THREAD_SLAVE_IO</literal>
+                    </para>
+                  </listitem>
+                  <listitem>
+                    <para>
+                      <literal>SYSTEM_THREAD_SLAVE_SQL</literal>
+                    </para>
+                  </listitem>
+                </itemizedlist>
+                For the <literal>system user</literal>, there's no host
+                specified in the <literal>Host</literal> column.
+              </para>
+            </listitem>
+            <listitem>
+              <para>
+                <literal>Host</literal>: The host of the client issuing the statement
+                (except for <literal>system user</literal> where there is no host)
+              </para>
+              <para>
+                As of MySQL 4.0.12,
+                <literal>SHOW PROCESSLIST</literal> reports the hostname for 
+                TCP/IP connections in
+                <literal><replaceable>host_name</replaceable>:<replaceable>client_port</replaceable></literal>
+                format to make it easier to determine which client is doing
+                what.
+              </para>
+            </listitem>
+            <listitem>
+              <para>
+                <literal>db</literal>: The default database, if selected,
+                otherwise <literal>NULL</literal>
+              </para>
+            </listitem>
+            <listitem>
+              <para>
+                <literal>Command</literal>: The value of that column corresponds
+                to the <literal>COM_<replaceable>xxx</replaceable></literal> 
+                commands of the client/server protocol; see
+                <xref linkend="server-status-variables"/>
+              </para>
+              <para>
+                The <literal>Command</literal>
+                value may be one of the following:
+                <literal>Binlog Dump</literal>,
+                <literal>Change user</literal>,
+                <literal>Close stmt</literal>,
+                <literal>Connect</literal>,
+                <literal>Connect Out</literal>,
+                <literal>Create DB</literal>,
+                <literal>Debug</literal>,
+                <literal>Delayed insert</literal>,
+                <literal>Drop DB</literal>,
+                <literal>Error</literal>,
+                <literal>Execute</literal>,
+                <literal>Fetch</literal>,
+                <literal>Field List</literal>,
+                <literal>Init DB</literal>,
+                <literal>Kill</literal>,
+                <literal>Long Data</literal>,
+                <literal>Ping</literal>,
+                <literal>Prepare</literal>,
+                <literal>Processlist</literal>,
+                <literal>Query</literal>,
+                <literal>Quit</literal>,
+                <literal>Refresh</literal>,
+                <literal>Register Slave</literal>,
+                <literal>Reset stmt</literal>,
+                <literal>Set option</literal>,
+                <literal>Shutdown</literal>,
+                <literal>Sleep</literal>,
+                <literal>Statistics</literal>,
+                <literal>Table Dump</literal>,
+                <literal>Time</literal>
+              </para>
+            </listitem>
+            <listitem>
+              <para>
+                <literal>Time</literal>: The time in seconds
+                between the start of the statement or command and now
+              </para>
+            </listitem>
+            <listitem>
+              <para>
+                <literal>State</literal>: An action, event, or state
+                which can be one of the following:
+                <literal>After create</literal>,
+                <literal>Analyzing</literal>,
+                <literal>Changing master</literal>,
+                <literal>Checking master version</literal>,
+                <literal>Checking table</literal>,
+                <literal>Connecting to master</literal>,
+                <literal>Copying to group table</literal>,
+                <literal>Copying to tmp table</literal>,
+                <literal>Creating delayed handler</literal>,
+                <literal>Creating index</literal>,
+                <literal>Creating sort index</literal>,
+                <literal>Creating table from master dump</literal>,
+                <literal>Creating tmp table</literal>,
+                <literal>Execution of init_command</literal>,
+                <literal>FULLTEXT initialization</literal>,
+                <literal>Finished reading one binlog; switching to next binlog</literal>,
+                <literal>Flushing tables</literal>,
+                <literal>Killed</literal>,
+                <literal>Killing slave</literal>,
+                <literal>Locked</literal>,
+                <literal>Making temp file </literal>,
+                <literal>Opening master dump table</literal>,
+                <literal>Opening table</literal>,
+                <literal>Opening tables</literal>,
+                <literal>Processing request</literal>,
+                <literal>Purging old relay logs</literal>,
+                <literal>Queueing master event to the relay log</literal>,
+                <literal>Reading event from the relay log</literal>,
+                <literal>Reading from net</literal>,
+                <literal>Reading master dump table data</literal>,
+                <literal>Rebuilding the index on master dump table</literal>,
+                <literal>Reconnecting after a failed binlog dump request</literal>,
+                <literal>Reconnecting after a failed master event read</literal>,
+                <literal>Registering slave on master</literal>,
+                <literal>Removing duplicates</literal>,
+                <literal>Reopen tables</literal>,
+                <literal>Repair by sorting</literal>,
+                <literal>Repair done</literal>,
+                <literal>Repair with keycache</literal>,
+                <literal>Requesting binlog dump</literal>,
+                <literal>Saving state</literal>,
+                <literal>Searching rows for update</literal>,
+                <literal>Sending binlog event to slave</literal>,
+                <literal>Sending data</literal>,
+                <literal>Sorting for group</literal>,
+                <literal>Sorting for order</literal>,
+                <literal>Sorting index</literal>,
+                <literal>Sorting result</literal>,
+                <literal>System lock</literal>,
+                <literal>Table lock</literal>,
+                <literal>Thread initialized</literal>,
+                <literal>Updating</literal>,
+                <literal>User lock</literal>,
+                <literal>Waiting for INSERT</literal>,
+                <literal>Waiting for master to send event</literal>,
+                <literal>Waiting for master update</literal>,
+                <literal>Waiting for slave mutex on exit</literal>,
+                <literal>Waiting for table</literal>,
+                <literal>Waiting for tables</literal>,
+                <literal>Waiting for the next event in relay log</literal>,
+                <literal>Waiting on cond</literal>,
+                <literal>Waiting to finalize termination</literal>,
+                <literal>Waiting to reconnect after a failed binlog dump request</literal>,
+                <literal>Waiting to reconnect after a failed master event read</literal>,
+                <literal>Writing to net</literal>,
+                <literal>allocating local table</literal>,
+                <literal>cleaning up</literal>,
+                <literal>closing tables</literal>,
+                <literal>converting HEAP to MyISAM</literal>,
+                <literal>copy to tmp table</literal>,
+                <literal>creating table</literal>,
+                <literal>deleting from main table</literal>,
+                <literal>deleting from reference tables</literal>,
+                <literal>discard_or_import_tablespace</literal>,
+                <literal>end</literal>,
+                <literal>freeing items</literal>,
+                <literal>got handler lock</literal>,
+                <literal>got old table</literal>,
+                <literal>info</literal>,
+                <literal>init</literal>,
+                <literal>insert</literal>,
+                <literal>logging slow query</literal>,
+                <literal>login</literal>,
+                <literal>preparing</literal>,
+                <literal>purging old relay logs</literal>,
+                <literal>query end</literal>,
+                <literal>removing tmp table</literal>,
+                <literal>rename</literal>,
+                <literal>rename result table</literal>,
+                <literal>reschedule</literal>,
+                <literal>setup</literal>,
+                <literal>starting slave</literal>,
+                <literal>statistics</literal>,
+                <literal>storing row into queue</literal>,
+                <literal>update</literal>,
+                <literal>updating</literal>,
+                <literal>updating main table</literal>,
+                <literal>updating reference tables</literal>,
+                <literal>upgrading lock</literal>,
+                <literal>waiting for delay_list</literal>,
+                <literal>waiting for handler insert</literal>,
+                <literal>waiting for handler lock</literal>,
+                <literal>waiting for handler open</literal>
+              </para>
+              <para>
+                The most common <literal>State</literal> values
+                are described in the rest of this section.
+                Most of the other <literal>State</literal>
+                values are useful only for finding bugs in the server.
+              </para>
+              <para>
+                For the <literal>SHOW PROCESSLIST</literal>
+                statement, the value of <literal>State</literal> is
+                <literal>NULL</literal>.
+              </para>
+            </listitem>
+            <listitem>
+              <para>
+                <literal>Info</literal>: The query that the thread was
+                issuing, but only if that query was still running by
+                the time <literal>SHOW PROCESSLIST</literal> was issued
+                (this is always the case for the 
+                <literal>SHOW PROCESSLIST</literal> statement itself,
+                and for long-running queries)
+              </para>
+            </listitem>
+          </itemizedlist>
+          
+        </para>
 
         <para>
           Some states commonly seen in the output from <literal>SHOW
@@ -14724,12 +15004,6 @@
           a problem that needs to be investigated.
         </para>
 
-        <para>
-          There are some other states that are not mentioned in the
-          preceding list, but many of them are useful only for finding
-          bugs in the server.
-        </para>
-
       </section>
 
       <section id="show-status">

Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml	2006-01-05 20:47:18 UTC (rev 695)
+++ trunk/refman-5.0/sql-syntax.xml	2006-01-05 22:47:03 UTC (rev 696)
@@ -15589,13 +15589,6 @@
         <remark role="help-description-end"/>
 
         <para>
-          This statement reports the hostname for TCP/IP connections in
-          <literal><replaceable>host_name</replaceable>:<replaceable>client_port</replaceable></literal>
-          format to make it easier to determine which client is doing
-          what.
-        </para>
-
-        <para>
           This statement is very useful if you get the <quote>too many
           connections</quote> error message and want to find out what is
           going on. MySQL reserves one extra connection to be used by
@@ -15604,6 +15597,293 @@
           and check the system (assuming that you are not giving this
           privilege to all your users).
         </para>
+        
+        <para>
+          The output of <literal>SHOW PROCESSLIST</literal> may look like this:
+          <programlisting>
+mysql> SHOW FULL PROCESSLIST\G
+*************************** 1. row ***************************
+Id: 1
+User: system user
+Host:
+db: NULL
+Command: Connect
+Time: 1030455
+State: Waiting for master to send event
+Info: NULL
+*************************** 2. row ***************************
+Id: 2
+User: system user
+Host:
+db: NULL
+Command: Connect
+Time: 1004
+State: Has read all relay log; waiting for the slave I/O thread to update it
+Info: NULL
+*************************** 3. row ***************************
+Id: 3112
+User: replikator
+Host: artemis:2204
+db: NULL
+Command: Binlog Dump
+Time: 2144
+State: Has sent all binlog to slave; waiting for binlog to be updated
+Info: NULL
+*************************** 4. row ***************************
+Id: 3113
+User: replikator
+Host: iconnect2:45781
+db: NULL
+Command: Binlog Dump
+Time: 2086
+State: Has sent all binlog to slave; waiting for binlog to be updated
+Info: NULL
+*************************** 5. row ***************************
+Id: 3123
+User: stefan
+Host: localhost
+db: apollon
+Command: Query
+Time: 0
+State: NULL
+Info: SHOW FULL PROCESSLIST
+5 rows in set (0.00 sec)
+          </programlisting>
+          The columns have the following meaning:
+          <itemizedlist>
+            <listitem>
+              <para>
+                <literal>Id</literal>: The connection identifier
+              </para>
+            </listitem>
+            <listitem>
+              <para>
+                <literal>User</literal>: The MySQL user who is issuing the statement
+              </para>
+              <para>
+                If the user is <literal>system user</literal>, 
+                it can be either of these:
+                <itemizedlist>
+                  <listitem>
+                    <para>
+                      <literal>SYSTEM_THREAD_DELAYED_INSERT</literal>
+                    </para>
+                  </listitem>
+                  <listitem>
+                    <para>
+                      <literal>SYSTEM_THREAD_SLAVE_IO</literal>
+                    </para>
+                  </listitem>
+                  <listitem>
+                    <para>
+                      <literal>SYSTEM_THREAD_SLAVE_SQL</literal>
+                    </para>
+                  </listitem>
+                </itemizedlist>
+                For the <literal>system user</literal>, there's no host
+                specified in the <literal>Host</literal> column.
+              </para>
+            </listitem>
+            <listitem>
+              <para>
+                <literal>Host</literal>: The host of the client issuing the statement
+                (except for <literal>system user</literal> where there is no host)
+              </para>
+              <para>
+                <literal>SHOW PROCESSLIST</literal> reports the hostname for 
+                TCP/IP connections in
+                <literal><replaceable>host_name</replaceable>:<replaceable>client_port</replaceable></literal>
+                format to make it easier to determine which client is doing
+                what.
+              </para>
+            </listitem>
+            <listitem>
+              <para>
+                <literal>db</literal>: The default database, if selected,
+                otherwise <literal>NULL</literal>
+              </para>
+            </listitem>
+            <listitem>
+              <para>
+                <literal>Command</literal>: The value of that column corresponds
+                to the <literal>COM_<replaceable>xxx</replaceable></literal> 
+                commands of the client/server protocol; see
+                <xref linkend="server-status-variables"/>
+              </para>
+              <para>
+                The <literal>Command</literal>
+                value may be one of the following:
+                <literal>Binlog Dump</literal>,
+                <literal>Change user</literal>,
+                <literal>Close stmt</literal>,
+                <literal>Connect</literal>,
+                <literal>Connect Out</literal>,
+                <literal>Create DB</literal>,
+                <literal>Debug</literal>,
+                <literal>Delayed insert</literal>,
+                <literal>Drop DB</literal>,
+                <literal>Error</literal>,
+                <literal>Execute</literal>,
+                <literal>Fetch</literal>,
+                <literal>Field List</literal>,
+                <literal>Init DB</literal>,
+                <literal>Kill</literal>,
+                <literal>Long Data</literal>,
+                <literal>Ping</literal>,
+                <literal>Prepare</literal>,
+                <literal>Processlist</literal>,
+                <literal>Query</literal>,
+                <literal>Quit</literal>,
+                <literal>Refresh</literal>,
+                <literal>Register Slave</literal>,
+                <literal>Reset stmt</literal>,
+                <literal>Set option</literal>,
+                <literal>Shutdown</literal>,
+                <literal>Sleep</literal>,
+                <literal>Statistics</literal>,
+                <literal>Table Dump</literal>,
+                <literal>Time</literal>
+              </para>
+            </listitem>
+            <listitem>
+              <para>
+                <literal>Time</literal>: The time in seconds
+                between the start of the statement or command and now
+              </para>
+            </listitem>
+            <listitem>
+              <para>
+                <literal>State</literal>: An action, event, or state
+                which can be one of the following:
+                <literal>After create</literal>,
+                <literal>Analyzing</literal>,
+                <literal>Changing master</literal>,
+                <literal>Checking master version</literal>,
+                <literal>Checking table</literal>,
+                <literal>Connecting to master</literal>,
+                <literal>Copying to group table</literal>,
+                <literal>Copying to tmp table</literal>,
+                <literal>Creating delayed handler</literal>,
+                <literal>Creating index</literal>,
+                <literal>Creating sort index</literal>,
+                <literal>Creating table from master dump</literal>,
+                <literal>Creating tmp table</literal>,
+                <literal>Execution of init_command</literal>,
+                <literal>FULLTEXT initialization</literal>,
+                <literal>Finished reading one binlog; switching to next binlog</literal>,
+                <literal>Flushing tables</literal>,
+                <literal>Killed</literal>,
+                <literal>Killing slave</literal>,
+                <literal>Locked</literal>,
+                <literal>Making temp file </literal>,
+                <literal>Opening master dump table</literal>,
+                <literal>Opening table</literal>,
+                <literal>Opening tables</literal>,
+                <literal>Processing request</literal>,
+                <literal>Purging old relay logs</literal>,
+                <literal>Queueing master event to the relay log</literal>,
+                <literal>Reading event from the relay log</literal>,
+                <literal>Reading from net</literal>,
+                <literal>Reading master dump table data</literal>,
+                <literal>Rebuilding the index on master dump table</literal>,
+                <literal>Reconnecting after a failed binlog dump request</literal>,
+                <literal>Reconnecting after a failed master event read</literal>,
+                <literal>Registering slave on master</literal>,
+                <literal>Removing duplicates</literal>,
+                <literal>Reopen tables</literal>,
+                <literal>Repair by sorting</literal>,
+                <literal>Repair done</literal>,
+                <literal>Repair with keycache</literal>,
+                <literal>Requesting binlog dump</literal>,
+                <literal>Saving state</literal>,
+                <literal>Searching rows for update</literal>,
+                <literal>Sending binlog event to slave</literal>,
+                <literal>Sending data</literal>,
+                <literal>Sorting for group</literal>,
+                <literal>Sorting for order</literal>,
+                <literal>Sorting index</literal>,
+                <literal>Sorting result</literal>,
+                <literal>System lock</literal>,
+                <literal>Table lock</literal>,
+                <literal>Thread initialized</literal>,
+                <literal>Updating</literal>,
+                <literal>User lock</literal>,
+                <literal>Waiting for INSERT</literal>,
+                <literal>Waiting for master to send event</literal>,
+                <literal>Waiting for master update</literal>,
+                <literal>Waiting for slave mutex on exit</literal>,
+                <literal>Waiting for table</literal>,
+                <literal>Waiting for tables</literal>,
+                <literal>Waiting for the next event in relay log</literal>,
+                <literal>Waiting on cond</literal>,
+                <literal>Waiting to finalize termination</literal>,
+                <literal>Waiting to reconnect after a failed binlog dump request</literal>,
+                <literal>Waiting to reconnect after a failed master event read</literal>,
+                <literal>Writing to net</literal>,
+                <literal>allocating local table</literal>,
+                <literal>cleaning up</literal>,
+                <literal>closing tables</literal>,
+                <literal>converting HEAP to MyISAM</literal>,
+                <literal>copy to tmp table</literal>,
+                <literal>creating table</literal>,
+                <literal>deleting from main table</literal>,
+                <literal>deleting from reference tables</literal>,
+                <literal>discard_or_import_tablespace</literal>,
+                <literal>end</literal>,
+                <literal>freeing items</literal>,
+                <literal>got handler lock</literal>,
+                <literal>got old table</literal>,
+                <literal>info</literal>,
+                <literal>init</literal>,
+                <literal>insert</literal>,
+                <literal>logging slow query</literal>,
+                <literal>login</literal>,
+                <literal>preparing</literal>,
+                <literal>purging old relay logs</literal>,
+                <literal>query end</literal>,
+                <literal>removing tmp table</literal>,
+                <literal>rename</literal>,
+                <literal>rename result table</literal>,
+                <literal>reschedule</literal>,
+                <literal>setup</literal>,
+                <literal>starting slave</literal>,
+                <literal>statistics</literal>,
+                <literal>storing row into queue</literal>,
+                <literal>update</literal>,
+                <literal>updating</literal>,
+                <literal>updating main table</literal>,
+                <literal>updating reference tables</literal>,
+                <literal>upgrading lock</literal>,
+                <literal>waiting for delay_list</literal>,
+                <literal>waiting for handler insert</literal>,
+                <literal>waiting for handler lock</literal>,
+                <literal>waiting for handler open</literal>
+              </para>
+              <para>
+                The most common <literal>State</literal> values
+                are described in the rest of this section.
+                Most of the other <literal>State</literal>
+                values are useful only for finding bugs in the server.
+              </para>
+              <para>
+                For the <literal>SHOW PROCESSLIST</literal>
+                statement, the value of <literal>State</literal> is
+                <literal>NULL</literal>.
+              </para>
+            </listitem>
+            <listitem>
+              <para>
+                <literal>Info</literal>: The query that the thread was
+                issuing, but only if that query was still running by
+                the time <literal>SHOW PROCESSLIST</literal> was issued
+                (this is always the case for the 
+                <literal>SHOW PROCESSLIST</literal> statement itself,
+                and for long-running queries)
+              </para>
+            </listitem>
+          </itemizedlist>
+          
+        </para>
 
         <para>
           Some states commonly seen in the output from <literal>SHOW
@@ -16022,12 +16302,6 @@
           a problem that needs to be investigated.
         </para>
 
-        <para>
-          There are some other states that are not mentioned in the
-          preceding list, but many of them are useful only for finding
-          bugs in the server.
-        </para>
-
       </section>
 
       <section id="show-status">

Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2006-01-05 20:47:18 UTC (rev 695)
+++ trunk/refman-5.1/sql-syntax.xml	2006-01-05 22:47:03 UTC (rev 696)
@@ -16062,13 +16062,6 @@
         <remark role="help-description-end"/>
 
         <para>
-          This statement reports the hostname for TCP/IP connections in
-          <literal><replaceable>host_name</replaceable>:<replaceable>client_port</replaceable></literal>
-          format to make it easier to determine which client is doing
-          what.
-        </para>
-
-        <para>
           This statement is very useful if you get the <quote>too many
           connections</quote> error message and want to find out what is
           going on. MySQL reserves one extra connection to be used by
@@ -16077,6 +16070,293 @@
           and check the system (assuming that you are not giving this
           privilege to all your users).
         </para>
+        
+        <para>
+          The output of <literal>SHOW PROCESSLIST</literal> may look like this:
+          <programlisting>
+mysql> SHOW FULL PROCESSLIST\G
+*************************** 1. row ***************************
+Id: 1
+User: system user
+Host:
+db: NULL
+Command: Connect
+Time: 1030455
+State: Waiting for master to send event
+Info: NULL
+*************************** 2. row ***************************
+Id: 2
+User: system user
+Host:
+db: NULL
+Command: Connect
+Time: 1004
+State: Has read all relay log; waiting for the slave I/O thread to update it
+Info: NULL
+*************************** 3. row ***************************
+Id: 3112
+User: replikator
+Host: artemis:2204
+db: NULL
+Command: Binlog Dump
+Time: 2144
+State: Has sent all binlog to slave; waiting for binlog to be updated
+Info: NULL
+*************************** 4. row ***************************
+Id: 3113
+User: replikator
+Host: iconnect2:45781
+db: NULL
+Command: Binlog Dump
+Time: 2086
+State: Has sent all binlog to slave; waiting for binlog to be updated
+Info: NULL
+*************************** 5. row ***************************
+Id: 3123
+User: stefan
+Host: localhost
+db: apollon
+Command: Query
+Time: 0
+State: NULL
+Info: SHOW FULL PROCESSLIST
+5 rows in set (0.00 sec)
+          </programlisting>
+          The columns have the following meaning:
+          <itemizedlist>
+            <listitem>
+              <para>
+                <literal>Id</literal>: The connection identifier
+              </para>
+            </listitem>
+            <listitem>
+              <para>
+                <literal>User</literal>: The MySQL user who is issuing the statement
+              </para>
+              <para>
+                If the user is <literal>system user</literal>, 
+                it can be either of these:
+                <itemizedlist>
+                  <listitem>
+                    <para>
+                      <literal>SYSTEM_THREAD_DELAYED_INSERT</literal>
+                    </para>
+                  </listitem>
+                  <listitem>
+                    <para>
+                      <literal>SYSTEM_THREAD_SLAVE_IO</literal>
+                    </para>
+                  </listitem>
+                  <listitem>
+                    <para>
+                      <literal>SYSTEM_THREAD_SLAVE_SQL</literal>
+                    </para>
+                  </listitem>
+                </itemizedlist>
+                For the <literal>system user</literal>, there's no host
+                specified in the <literal>Host</literal> column.
+              </para>
+            </listitem>
+            <listitem>
+              <para>
+                <literal>Host</literal>: The host of the client issuing the statement
+                (except for <literal>system user</literal> where there is no host)
+              </para>
+              <para>
+                <literal>SHOW PROCESSLIST</literal> reports the hostname for 
+                TCP/IP connections in
+                <literal><replaceable>host_name</replaceable>:<replaceable>client_port</replaceable></literal>
+                format to make it easier to determine which client is doing
+                what.
+              </para>
+            </listitem>
+            <listitem>
+              <para>
+                <literal>db</literal>: The default database, if selected,
+                otherwise <literal>NULL</literal>
+              </para>
+            </listitem>
+            <listitem>
+              <para>
+                <literal>Command</literal>: The value of that column corresponds
+                to the <literal>COM_<replaceable>xxx</replaceable></literal> 
+                commands of the client/server protocol; see
+                <xref linkend="server-status-variables"/>
+              </para>
+              <para>
+                The <literal>Command</literal>
+                value may be one of the following:
+                <literal>Binlog Dump</literal>,
+                <literal>Change user</literal>,
+                <literal>Close stmt</literal>,
+                <literal>Connect</literal>,
+                <literal>Connect Out</literal>,
+                <literal>Create DB</literal>,
+                <literal>Debug</literal>,
+                <literal>Delayed insert</literal>,
+                <literal>Drop DB</literal>,
+                <literal>Error</literal>,
+                <literal>Execute</literal>,
+                <literal>Fetch</literal>,
+                <literal>Field List</literal>,
+                <literal>Init DB</literal>,
+                <literal>Kill</literal>,
+                <literal>Long Data</literal>,
+                <literal>Ping</literal>,
+                <literal>Prepare</literal>,
+                <literal>Processlist</literal>,
+                <literal>Query</literal>,
+                <literal>Quit</literal>,
+                <literal>Refresh</literal>,
+                <literal>Register Slave</literal>,
+                <literal>Reset stmt</literal>,
+                <literal>Set option</literal>,
+                <literal>Shutdown</literal>,
+                <literal>Sleep</literal>,
+                <literal>Statistics</literal>,
+                <literal>Table Dump</literal>,
+                <literal>Time</literal>
+              </para>
+            </listitem>
+            <listitem>
+              <para>
+                <literal>Time</literal>: The time in seconds
+                between the start of the statement or command and now
+              </para>
+            </listitem>
+            <listitem>
+              <para>
+                <literal>State</literal>: An action, event, or state
+                which can be one of the following:
+                <literal>After create</literal>,
+                <literal>Analyzing</literal>,
+                <literal>Changing master</literal>,
+                <literal>Checking master version</literal>,
+                <literal>Checking table</literal>,
+                <literal>Connecting to master</literal>,
+                <literal>Copying to group table</literal>,
+                <literal>Copying to tmp table</literal>,
+                <literal>Creating delayed handler</literal>,
+                <literal>Creating index</literal>,
+                <literal>Creating sort index</literal>,
+                <literal>Creating table from master dump</literal>,
+                <literal>Creating tmp table</literal>,
+                <literal>Execution of init_command</literal>,
+                <literal>FULLTEXT initialization</literal>,
+                <literal>Finished reading one binlog; switching to next binlog</literal>,
+                <literal>Flushing tables</literal>,
+                <literal>Killed</literal>,
+                <literal>Killing slave</literal>,
+                <literal>Locked</literal>,
+                <literal>Making temp file </literal>,
+                <literal>Opening master dump table</literal>,
+                <literal>Opening table</literal>,
+                <literal>Opening tables</literal>,
+                <literal>Processing request</literal>,
+                <literal>Purging old relay logs</literal>,
+                <literal>Queueing master event to the relay log</literal>,
+                <literal>Reading event from the relay log</literal>,
+                <literal>Reading from net</literal>,
+                <literal>Reading master dump table data</literal>,
+                <literal>Rebuilding the index on master dump table</literal>,
+                <literal>Reconnecting after a failed binlog dump request</literal>,
+                <literal>Reconnecting after a failed master event read</literal>,
+                <literal>Registering slave on master</literal>,
+                <literal>Removing duplicates</literal>,
+                <literal>Reopen tables</literal>,
+                <literal>Repair by sorting</literal>,
+                <literal>Repair done</literal>,
+                <literal>Repair with keycache</literal>,
+                <literal>Requesting binlog dump</literal>,
+                <literal>Saving state</literal>,
+                <literal>Searching rows for update</literal>,
+                <literal>Sending binlog event to slave</literal>,
+                <literal>Sending data</literal>,
+                <literal>Sorting for group</literal>,
+                <literal>Sorting for order</literal>,
+                <literal>Sorting index</literal>,
+                <literal>Sorting result</literal>,
+                <literal>System lock</literal>,
+                <literal>Table lock</literal>,
+                <literal>Thread initialized</literal>,
+                <literal>Updating</literal>,
+                <literal>User lock</literal>,
+                <literal>Waiting for INSERT</literal>,
+                <literal>Waiting for master to send event</literal>,
+                <literal>Waiting for master update</literal>,
+                <literal>Waiting for slave mutex on exit</literal>,
+                <literal>Waiting for table</literal>,
+                <literal>Waiting for tables</literal>,
+                <literal>Waiting for the next event in relay log</literal>,
+                <literal>Waiting on cond</literal>,
+                <literal>Waiting to finalize termination</literal>,
+                <literal>Waiting to reconnect after a failed binlog dump request</literal>,
+                <literal>Waiting to reconnect after a failed master event read</literal>,
+                <literal>Writing to net</literal>,
+                <literal>allocating local table</literal>,
+                <literal>cleaning up</literal>,
+                <literal>closing tables</literal>,
+                <literal>converting HEAP to MyISAM</literal>,
+                <literal>copy to tmp table</literal>,
+                <literal>creating table</literal>,
+                <literal>deleting from main table</literal>,
+                <literal>deleting from reference tables</literal>,
+                <literal>discard_or_import_tablespace</literal>,
+                <literal>end</literal>,
+                <literal>freeing items</literal>,
+                <literal>got handler lock</literal>,
+                <literal>got old table</literal>,
+                <literal>info</literal>,
+                <literal>init</literal>,
+                <literal>insert</literal>,
+                <literal>logging slow query</literal>,
+                <literal>login</literal>,
+                <literal>preparing</literal>,
+                <literal>purging old relay logs</literal>,
+                <literal>query end</literal>,
+                <literal>removing tmp table</literal>,
+                <literal>rename</literal>,
+                <literal>rename result table</literal>,
+                <literal>reschedule</literal>,
+                <literal>setup</literal>,
+                <literal>starting slave</literal>,
+                <literal>statistics</literal>,
+                <literal>storing row into queue</literal>,
+                <literal>update</literal>,
+                <literal>updating</literal>,
+                <literal>updating main table</literal>,
+                <literal>updating reference tables</literal>,
+                <literal>upgrading lock</literal>,
+                <literal>waiting for delay_list</literal>,
+                <literal>waiting for handler insert</literal>,
+                <literal>waiting for handler lock</literal>,
+                <literal>waiting for handler open</literal>
+              </para>
+              <para>
+                The most common <literal>State</literal> values
+                are described in the rest of this section.
+                Most of the other <literal>State</literal>
+                values are useful only for finding bugs in the server.
+              </para>
+              <para>
+                For the <literal>SHOW PROCESSLIST</literal>
+                statement, the value of <literal>State</literal> is
+                <literal>NULL</literal>.
+              </para>
+            </listitem>
+            <listitem>
+              <para>
+                <literal>Info</literal>: The query that the thread was
+                issuing, but only if that query was still running by
+                the time <literal>SHOW PROCESSLIST</literal> was issued
+                (this is always the case for the 
+                <literal>SHOW PROCESSLIST</literal> statement itself,
+                and for long-running queries)
+              </para>
+            </listitem>
+          </itemizedlist>
+          
+        </para>
 
         <para>
           Some states commonly seen in the output from <literal>SHOW
@@ -16495,12 +16775,6 @@
           a problem that needs to be investigated.
         </para>
 
-        <para>
-          There are some other states that are not mentioned in the
-          preceding list, but many of them are useful only for finding
-          bugs in the server.
-        </para>
-
       </section>
 
       <section id="show-status">

Thread
svn commit - mysqldoc@docsrva: r696 - in trunk: refman-4.1 refman-5.0 refman-5.1stefan5 Jan