Movatterモバイル変換

INFORMATION_SCHEMA.PROCESSLIST is deprecated and subject to removal in a future MySQL release. As such, the implementation ofSHOW PROCESSLIST which uses this table is also deprecated. It is recommended to use the Performance Schema implementation ofPROCESSLIST instead.

• ID

  The connection identifier. This is the same value displayed in theId column of theSHOW PROCESSLIST statement, displayed in thePROCESSLIST_ID column of the Performance Schemathreads table, and returned by theCONNECTION_ID() function within the thread.

• USER

  The MySQL user who issued the statement. A value ofsystem 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 or SQL thread used on replica hosts. Forsystem user, there is no host specified in theHost 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 (seeSection 27.5, “Using the Event Scheduler”).

  Note

  AUSER value ofsystem user is distinct from theSYSTEM_USER privilege. The former designates internal threads. The latter distinguishes the system user and regular user account categories (seeSection 8.2.11, “Account Categories”).

• HOST

  The host name of the client issuing the statement (except forsystem user, for which there is no host). The host name for TCP/IP connections is reported inhost_name:client_port format to make it easier to determine which client is doing what.

• DB

  The default database for the thread, orNULL if none has been selected.

• COMMAND

  The type of command the thread is executing on behalf of the client, orSleep if the session is idle. For descriptions of thread commands, seeSection 10.14, “Examining Server Thread (Process) Information”. The value of this column corresponds to theCOM_xxx commands of the client/server protocol andCom_xxx status variables. SeeSection 7.1.10, “Server Status Variables”.

• TIME

  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. SeeSection 19.2.3, “Replication Threads”.

• STATE

  An action, event, or state that indicates what the thread is doing. For descriptions ofSTATE values, seeSection 10.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.

• INFO

  The statement the thread is executing, orNULL 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 aCALL statement executes a stored procedure that is executing aSELECT statement, theINFO value shows theSELECT statement.

• PROCESSLIST is a nonstandardINFORMATION_SCHEMA table.

• Like the output from theSHOW PROCESSLIST statement, thePROCESSLIST table provides information about all threads, even those belonging to other users, if you have thePROCESS privilege. Otherwise (without thePROCESS 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.

• If an SQL statement refers to thePROCESSLIST table, MySQL populates the entire table once, when statement execution begins, so there is read consistency during the statement. There is no read consistency for a multi-statement transaction.