Emergency

Process List

This page describes Percona changes to both the standard MySQL SHOW PROCESSLIST command and the standard MySQL INFORMATION_SCHEMA table PROCESSLIST.

The changes that have been made as of version 5.6 of the server are:

Version Specific Information

  • 5.6.5-60.0:
    • Added column TIME_MS to table PROCESSLIST.
  • 5.6.11-60.3:
    • Added ROWS_SENT and ROWS_EXAMINED columns to table PROCESSLIST.`

INFORMATION_SCHEMA Tables

table INFORMATION_SCHEMA.PROCESSLIST

This table implements modifications to the standard MySQL INFORMATION_SCHEMA table PROCESSLIST.

Columns:
  • ID – The connection identifier.
  • USER – The MySQL user who issued the statement.
  • HOST – The host name of the client issuing the statement.
  • DB – The default database, if one is selected, otherwise NULL.
  • COMMAND – The type of command the thread is executing.
  • TIME – The time in seconds that the thread has been in its current state.
  • STATE – An action, event, or state that indicates what the thread is doing.
  • INFO – The statement that the thread is executing, or NULL if it is not executing any statement.
  • TIME_MS – The time in milliseconds that the thread has been in its current state.
  • ROWS_SENT – The number of rows query sent.
  • ROWS_EXAMINED – The number of rows scanned for a query.

Example Output

Table PROCESSLIST:

mysql> SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;

+----+------+-----------+--------------------+---------+------+-----------+---------------------------+---------+-----------+---------------+
| ID | USER | HOST      | DB                 | COMMAND | TIME | STATE     | INFO                      | TIME_MS | ROWS_SENT | ROWS_EXAMINED |
+----+------+-----------+--------------------+---------+------+-----------+---------------------------+---------+-----------+---------------+
| 12 | root | localhost | information_schema | Query   |    0 | executing | select * from processlist |       0 |         0 |             0 |
+----+------+-----------+--------------------+---------+------+-----------+---------------------------+---------+-----------+---------------+

Table Of Contents

Previous topic

Show Lock Names

Next topic

Misc. INFORMATION_SCHEMA Tables