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.1 | stefan | 5 Jan |
