|
|
| Applications |
| Mailing Lists |
| Miscellaneous |
| Operating Systems |
| Programming |
svn commit - mysqldoc@docsrva: r6970 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-5.2
From: <paul(at)mysql.com>
Date: Fri Jun 29 2007 - 19:46:46 EDT
Name: svk:merge
Date: Fri Jun 29 2007 - 19:46:46 EDT
Author: paul
Date: 2007-06-30 01:46:37 +0200 (Sat, 30 Jun 2007)
New Revision: 6970
Log:
r22288@frost: paul | 2007-06-29 14:56:46 -0500
Start section specifically for documenting thread commands/states.
Modified:
trunk/refman-4.1/optimization.xml trunk/refman-5.0/optimization.xml trunk/refman-5.1/optimization.xml trunk/refman-5.2/optimization.xml
Property changes on: trunk
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:27013 7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:22287 b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218 bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:18307 + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:27013 7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:22288 b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218 bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:18307
Modified: trunk/refman-4.1/optimization.xml
- trunk/refman-4.1/optimization.xml 2007-06-29 23:46:01 UTC (rev 6969) +++ trunk/refman-4.1/optimization.xml 2007-06-29 23:46:37 UTC (rev 6970) Changed blocks: 1, Lines Added: 898, Lines Deleted: 0; 24873 bytes
@@ -8652,6 +8652,904 @@
</section>
++ + +Examining Thread Information + ++ When you are attempting to ascertain what your MySQL server is + doing, it can be helpful to examine the process list, which is + the set of threads currently executing within the server. + Process list information is available from these sources: + + ++ + + ++ + ++ The +SHOW [FULL] PROCESSLIST statement + () + + + ++ The +SHOW PROFILE statement + () + + + ++ The +INFORMATION_SCHEMA +PROCESSLIST table + () + + + ++ The +myqladmin processlist command + () + + You can always view information about your own threads. To view + information about threads being executed for other accounts, you + must have the + +PROCESS privilege. ++ The names are specific to SHOW PROCESSLIST and are not + necessarily the same for SHOW PROFILE or I_S.PROCESSLIST. + + ++ Each process list entry contains several pieces of information: + + ++ + + ++ + ++ +Id is the connection identifier for the + client associated with the thread. ++ + ++ +User andHost indicate + the account associated with the thread. ++ + ++ +db is the default database for the + thread, orNULL if none is selected. ++ + ++ +Command andState + indicate what the thread is doing. ++ + ++ +Time indicates how long the thread has + been in its current state. ++ + ++ +Info contains the text of the statement + being executed by the thread, orNULL if + it is not executing one. By default, this value contains + only the first 100 characters of the statement. To see the + complete statements, useSHOW FULL + PROCESSLIST . ++ Remove the xref if I move the replication thread sections here. + + ++ The following sections list the possible + + +Command values, andState + values grouped by category. The meaning for some of these values + is self-evident. For others, additional description is provided. + AdditionalState values are given in +. + + + + +Thread Command Values + ++ + +thread commands ++ A thread can have any of the following + + +Command values: ++ + + ++ + ++ + ++ + +Binlog Dump +thread command ++ + +thread command +Binlog Dump +Binlog Dump ++ This is a thread on a master server for sending binary log + contents to a slave server. + ++ + ++ + ++ + +Change user +thread command ++ + +thread command +Change user +Change user ++ The thread is executing a change-user operation. + ++ + ++ + ++ + +Close stmt +thread command ++ + +thread command +Close stmt +Close stmt ++ The thread is closing a prepared statement. + ++ + ++ + ++ + +Connect +thread command ++ + +thread command +Connect +Connect ++ A replication slave is connected to its master. + ++ + ++ + ++ + +Connect Out +thread command ++ + +thread command +Connect Out +Connect Out ++ A replication slave is connecting to its master. + ++ + ++ + ++ + +Create DB +thread command ++ + +thread command +Create DB +Create DB ++ The thread is executing a create-database operation. + ++ + ++ + ++ + +Daemon +thread command ++ + +thread command +Daemon +Daemon ++ This thread is internal to the server, not a thread that + services a client connection. + ++ + ++ + ++ + +Debug +thread command ++ + +thread command +Debug +Debug ++ The thread is generating debugging information. + ++ + ++ + ++ + +Delayed insert +thread command ++ + +thread command +Delayed insert +Delayed insert ++ The thread is a delayed-insert handler. + ++ + ++ + ++ + +Drop DB +thread command ++ + +thread command +Drop DB +Drop DB ++ The thread is executing a drop-database operation. + ++ + ++ ++ + +Error +thread command ++ + +thread command +Error +Error ++ + ++ + ++ + +Execute +thread command ++ + +thread command +Execute +Execute ++ The thread is executing a prepared statement. + ++ + ++ + ++ + +Fetch +thread command ++ + +thread command +Fetch +Fetch ++ The thread is fetching the results from executing a + prepared statement. + ++ + ++ + ++ + +Field List +thread command ++ + +thread command +Field List +Field List ++ The thread is retrieving information for table columns. + ++ + ++ + ++ + +Init DB +thread command ++ + +thread command +Init DB +Init DB ++ The thread is selecting a default database. + ++ + ++ + ++ + +Kill +thread command ++ + +thread command +Kill +Kill ++ The thread is killing another thread. + ++ + ++ + ++ + +Long Data +thread command ++ + +thread command +Long Data +Long Data ++ The thread is retrieving long data in the result of + executing a prepared statement. + ++ + ++ + ++ + +Ping +thread command ++ + +thread command +Ping +Ping ++ The thread is handling a server-ping request. + ++ + ++ + ++ + +Prepare +thread command ++ + +thread command +Prepare +Prepare ++ The thread is preparing a prepared statement. + ++ + ++ + ++ + +Processlist +thread command ++ + +thread command +Processlist +Processlist ++ The thread is producing information about server threads. + ++ + ++ + ++ + +Query +thread command ++ + +thread command +Query +Query ++ The thread is executing a statement. + ++ + ++ + ++ + +Quit +thread command ++ + +thread command +Quit +Quit ++ The thread is terminating. + ++ + ++ + ++ + +Refresh +thread command ++ + +thread command +Refresh +Refresh ++ The thread is flushing table, logs, or caches, or + resetting status variable or replication server + information. + ++ + ++ + ++ + +Register Slave +thread command ++ + +thread command +Register Slave +Register Slave ++ The thread is registering a slave server. + ++ + ++ + ++ + +Reset stmt +thread command ++ + +thread command +Reset stmt +Reset stmt ++ The thread is resetting a prepared statement. + ++ + ++ + ++ + +Set option +thread command ++ + +thread command +Set option +Set option ++ The thread is setting or resetting a client + statement-execution option. + ++ + ++ + ++ + +Shutdown +thread command ++ + +thread command +Shutdown +Shutdown ++ The thread is shutting down the server. + ++ + ++ + ++ + +Sleep +thread command ++ + +thread command +Sleep +Sleep ++ The thread is waiting for the client to send a new + statement to it. + ++ + ++ + ++ + +Statistics +thread command ++ + +thread command +Statistics +Statistics ++ The thread is producing server-status information. + ++ + ++ + ++ + +Table Dump +thread command ++ + +thread command +Table Dump +Table Dump ++ The thread is sending table contents to a slave server. + ++ + ++ + ++ + +Time +thread command ++ + +thread command +Time +Time ++ Unused. + ++ + + +Event Scheduler Thread States + ++ + +thread states +event scheduler ++ + +event scheduler +thread states ++ These states occur for the Event Scheduler thread, threads + that are created to execute scheduled events, or threads that + terminate the scheduler. + + ++ + + ++ + ++ + ++ + +Clearing +thread state ++ + +thread state +Clearing +Clearing ++ The scheduler thread or a thread that was executing an + event is terminating and is about to end. + ++ + ++ + ++ + +Initialized +thread state ++ + +thread state +Initialized +Initialized ++ The scheduler thread or a thread that will execute an + event has been initialized. + ++ + ++ + ++ + +Waiting for next activation +thread state ++ + +thread state +Waiting for next activation +Waiting for next activation ++ The scheduler has a non-empty event queue but the next + activation is in the future. + ++ + ++ + ++ + +Waiting for scheduler to stop +thread state ++ + +thread state +Waiting for scheduler to stop +Waiting for scheduler to stop ++ The thread issued +SET GLOBAL + event_scheduler=OFF and is waiting for the + scheduler to stop. ++ + ++ + ++ + +Waiting on empty queue +thread state ++ + +thread state +Waiting on empty queue +Waiting on empty queue ++ The scheduler's event queue is empty and it is sleeping. + +How Compiling and Linking Affects the Speed of MySQL
Modified: trunk/refman-5.0/optimization.xml
- trunk/refman-5.0/optimization.xml 2007-06-29 23:46:01 UTC (rev 6969) +++ trunk/refman-5.0/optimization.xml 2007-06-29 23:46:37 UTC (rev 6970) Changed blocks: 1, Lines Added: 898, Lines Deleted: 0; 24875 bytes
@@ -10940,6 +10940,904 @@
</section>
++ + Examining Thread Information + ++ When you are attempting to ascertain what your MySQL server is + doing, it can be helpful to examine the process list, which is + the set of threads currently executing within the server. + Process list information is available from these sources: + + ++ + + ++ + ++ The +SHOW [FULL] PROCESSLIST statement + () + + + ++ The +SHOW PROFILE statement + () + + + ++ The +INFORMATION_SCHEMA +PROCESSLIST table + () + + + ++ The +myqladmin processlist command + () + + You can always view information about your own threads. To view + information about threads being executed for other accounts, you + must have the + +PROCESS privilege. ++ The names are specific to SHOW PROCESSLIST and are not + necessarily the same for SHOW PROFILE or I_S.PROCESSLIST. + + ++ Each process list entry contains several pieces of information: + + ++ + + ++ + ++ +Id is the connection identifier for the + client associated with the thread. ++ + ++ +User andHost indicate + the account associated with the thread. ++ + ++ +db is the default database for the + thread, orNULL if none is selected. ++ + ++ +Command andState + indicate what the thread is doing. ++ + ++ +Time indicates how long the thread has + been in its current state. ++ + ++ +Info contains the text of the statement + being executed by the thread, orNULL if + it is not executing one. By default, this value contains + only the first 100 characters of the statement. To see the + complete statements, useSHOW FULL + PROCESSLIST . ++ Remove the xref if I move the replication thread sections here. + + ++ The following sections list the possible + + +Command values, andState + values grouped by category. The meaning for some of these values + is self-evident. For others, additional description is provided. + AdditionalState values are given in +. + + + + +Thread Command Values + ++ + +thread commands ++ A thread can have any of the following + + +Command values: ++ + + ++ + ++ + ++ + +Binlog Dump +thread command ++ + +thread command +Binlog Dump +Binlog Dump ++ This is a thread on a master server for sending binary log + contents to a slave server. + ++ + ++ + ++ + +Change user +thread command ++ + +thread command +Change user +Change user ++ The thread is executing a change-user operation. + ++ + ++ + ++ + +Close stmt +thread command ++ + +thread command +Close stmt +Close stmt ++ The thread is closing a prepared statement. + ++ + ++ + ++ + +Connect +thread command ++ + +thread command +Connect +Connect ++ A replication slave is connected to its master. + ++ + ++ + ++ + +Connect Out +thread command ++ + +thread command +Connect Out +Connect Out ++ A replication slave is connecting to its master. + ++ + ++ + ++ + +Create DB +thread command ++ + +thread command +Create DB +Create DB ++ The thread is executing a create-database operation. + ++ + ++ + ++ + +Daemon +thread command ++ + +thread command +Daemon +Daemon ++ This thread is internal to the server, not a thread that + services a client connection. + ++ + ++ + ++ + +Debug +thread command ++ + +thread command +Debug +Debug ++ The thread is generating debugging information. + ++ + ++ + ++ + +Delayed insert +thread command ++ + +thread command +Delayed insert +Delayed insert ++ The thread is a delayed-insert handler. + ++ + ++ + ++ + +Drop DB +thread command ++ + +thread command +Drop DB +Drop DB ++ The thread is executing a drop-database operation. + ++ + ++ ++ + +Error +thread command ++ + +thread command +Error +Error ++ + ++ + ++ + +Execute +thread command ++ + +thread command +Execute +Execute ++ The thread is executing a prepared statement. + ++ + ++ + ++ + +Fetch +thread command ++ + +thread command +Fetch +Fetch ++ The thread is fetching the results from executing a + prepared statement. + ++ + ++ + ++ + +Field List +thread command ++ + +thread command +Field List +Field List ++ The thread is retrieving information for table columns. + ++ + ++ + ++ + +Init DB +thread command ++ + +thread command +Init DB +Init DB ++ The thread is selecting a default database. + ++ + ++ + ++ + +Kill +thread command ++ + +thread command +Kill +Kill ++ The thread is killing another thread. + ++ + ++ + ++ + +Long Data +thread command ++ + +thread command +Long Data +Long Data ++ The thread is retrieving long data in the result of + executing a prepared statement. + ++ + ++ + ++ + +Ping +thread command ++ + +thread command +Ping +Ping ++ The thread is handling a server-ping request. + ++ + ++ + ++ + +Prepare +thread command ++ + +thread command +Prepare +Prepare ++ The thread is preparing a prepared statement. + ++ + ++ + ++ + +Processlist +thread command ++ + +thread command +Processlist +Processlist ++ The thread is producing information about server threads. + ++ + ++ + ++ + +Query +thread command ++ + +thread command +Query +Query ++ The thread is executing a statement. + ++ + ++ + ++ + +Quit +thread command ++ + +thread command +Quit +Quit ++ The thread is terminating. + ++ + ++ + ++ + +Refresh +thread command ++ + +thread command +Refresh +Refresh ++ The thread is flushing table, logs, or caches, or + resetting status variable or replication server + information. + ++ + ++ + ++ + +Register Slave +thread command ++ + +thread command +Register Slave +Register Slave ++ The thread is registering a slave server. + ++ + ++ + ++ + +Reset stmt +thread command ++ + +thread command +Reset stmt +Reset stmt ++ The thread is resetting a prepared statement. + ++ + ++ + ++ + +Set option +thread command ++ + +thread command +Set option +Set option ++ The thread is setting or resetting a client + statement-execution option. + ++ + ++ + ++ + +Shutdown +thread command ++ + +thread command +Shutdown +Shutdown ++ The thread is shutting down the server. + ++ + ++ + ++ + +Sleep +thread command ++ + +thread command +Sleep +Sleep ++ The thread is waiting for the client to send a new + statement to it. + ++ + ++ + ++ + +Statistics +thread command ++ + +thread command +Statistics +Statistics ++ The thread is producing server-status information. + ++ + ++ + ++ + +Table Dump +thread command ++ + +thread command +Table Dump +Table Dump ++ The thread is sending table contents to a slave server. + ++ + ++ + ++ + +Time +thread command ++ + +thread command +Time +Time ++ Unused. + ++ + Event Scheduler Thread States + ++ + +thread states +event scheduler ++ + +event scheduler +thread states ++ These states occur for the Event Scheduler thread, threads + that are created to execute scheduled events, or threads that + terminate the scheduler. + + ++ + + + ++ + ++ + +Clearing +thread state ++ + +thread state +Clearing +Clearing ++ The scheduler thread or a thread that was executing an + event is terminating and is about to end. + ++ + + ++ + +Initialized +thread state ++ + +thread state +Initialized +Initialized ++ The scheduler thread or a thread that will execute an + event has been initialized.