相关文章推荐
伤情的遥控器  ·  缅甸国家概况--时政--人民网·  1 年前    · 
热心的钥匙扣  ·  日本与中亚五国举行外长会 ...·  2 年前    · 
健壮的芹菜  ·  胧月为什么叫恒娖 – 快看漫画问答·  2 年前    · 
阳刚的橙子  ·  川普大厦(Trump ...·  2 年前    · 
气势凌人的企鹅  ·  国王理查德迅雷下载_国王理查德720P_国王 ...·  2 年前    · 
Code  ›  MySQL :: MySQL 8.0 Reference Manual :: 13.7.7.29 SHOW PROCESSLIST Statement
host
https://dev.mysql.com/doc/refman/8.0/en/show-processlist.html
心软的刺猬
2 年前
Statements That Cause an Implicit Commit
SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT Statements
LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE Statements
LOCK TABLES and UNLOCK TABLES Statements
SET TRANSACTION Statement
XA Transactions
XA Transaction SQL Statements
XA Transaction States
Restrictions on XA Transactions
CREATE FUNCTION Statement for Loadable Functions
DROP FUNCTION Statement for Loadable Functions
INSTALL COMPONENT Statement
INSTALL PLUGIN Statement
UNINSTALL COMPONENT Statement
UNINSTALL PLUGIN Statement
SHOW [FULL] PROCESSLIST

The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. The SHOW PROCESSLIST statement is one source of process information. For a comparison of this statement with other sources, see Sources of Process Information . As of MySQL 8.0.22, an alternative implementation for SHOW PROCESSLIST is available based on the Performance Schema processlist table, which, unlike the default SHOW PROCESSLIST implementation, does not require a mutex and has better performance characteristics. For details, see Section 27.12.21.6, “The processlist Table” . If you have the PROCESS privilege, you can see all threads, even those belonging to other users. Otherwise (without the PROCESS privilege), nonanonymous users have access to information about their own threads but not threads for other users, and anonymous users have no access to thread information. Without the FULL keyword, SHOW PROCESSLIST displays only the first 100 characters of each statement in the Info field. The SHOW PROCESSLIST statement is very useful if you get the “ too many connections ” error message and want to find out what is going on. MySQL reserves one extra connection to be used by accounts that have the CONNECTION_ADMIN privilege (or the deprecated SUPER privilege), to ensure that administrators should always be able to connect and check the system (assuming that you are not giving this privilege to all your users). Threads can be killed with the KILL statement. See Section 13.7.8.4, “KILL Statement” . Example of SHOW PROCESSLIST output:

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

SHOW PROCESSLIST output has these columns: The connection identifier. This is the same value displayed in the ID column of the INFORMATION_SCHEMA PROCESSLIST table, displayed in the PROCESSLIST_ID column of the Performance Schema threads table, and returned by the CONNECTION_ID() function within the thread. The MySQL user who issued the statement. A value of system user refers to a nonclient thread spawned by the server to handle tasks internally, for example, a delayed-row handler thread or an I/O (receiver) or SQL (applier) thread used on replica hosts. For system user , there is no host specified in the Host column. unauthenticated user refers to a thread that has become associated with a client connection but for which authentication of the client user has not yet occurred. event_scheduler refers to the thread that monitors scheduled events (see Section 25.4, “Using the Event Scheduler” ). user is distinct from the SYSTEM_USER privilege. The former designates internal threads. The latter distinguishes the system user and regular user account categories (see Section 6.2.11, “Account Categories” ). The host name of the client issuing the statement (except for system user , for which there is no host). The host name for TCP/IP connections is reported in host_name : client_port format to make it easier to determine which client is doing what. The default database for the thread, or NULL if none has been selected. Command The type of command the thread is executing on behalf of the client, or Sleep if the session is idle. For descriptions of thread commands, see Section 8.14, “Examining Server Thread (Process) Information” . The value of this column corresponds to the COM_ xxx commands of the client/server protocol and Com_ xxx status variables. See Section 5.1.10, “Server Status Variables” . The time in seconds that the thread has been in its current state. For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. See Section 17.2.3, “Replication Threads” . State An action, event, or state that indicates what the thread is doing. For descriptions of State values, see Section 8.14, “Examining Server Thread (Process) Information” . Most states correspond to very quick operations. If a thread stays in a given state for many seconds, there might be a problem that needs to be investigated. The statement the thread is executing, or NULL if it is executing no statement. The statement might be the one sent to the server, or an innermost statement if the statement executes other statements. For example, if a CALL statement executes a stored procedure that is executing a SELECT statement, the Info value shows the SELECT statement.

 
推荐文章
伤情的遥控器  ·  缅甸国家概况--时政--人民网
1 年前
热心的钥匙扣  ·  日本与中亚五国举行外长会 将放宽签证扩大援助|外长|中亚|五国_新浪新闻
2 年前
健壮的芹菜  ·  胧月为什么叫恒娖 – 快看漫画问答
2 年前
阳刚的橙子  ·  川普大厦(Trump Tower)是一座怎样的大厦? - 知乎
2 年前
气势凌人的企鹅  ·  国王理查德迅雷下载_国王理查德720P_国王理查德1080P_迅雷电影天堂
2 年前
今天看啥   ·   Py中国   ·   codingpro   ·   小百科   ·   link之家   ·   卧龙AI搜索
删除内容请联系邮箱 2879853325@qq.com
Code - 代码工具平台
© 2024 ~ 沪ICP备11025650号