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.5 of the server are:
- SHOW PROCESSLIST command:
- added columns ROWS_EXAMINED, ROWS_SENT, and ROWS_READ
- PROCESSLIST table:
- added columns TIME_MS, ROWS_EXAMINED, ROWS_SENT, and ROWS_READ
- 5.5.10-20.1:
- Added columns ROWS_EXAMINED, ROWS_SENT, and ROWS_READ to SHOW PROCESSLIST command.
- Added columns ROWS_EXAMINED, ROWS_SENT, and ROWS_READ to PROCESSLIST table.
This table implements modifications to the standard MySQL INFORMATION_SCHEMA table PROCESSLIST.
| Columns: |
|
|---|
SHOW PROCESSLIST Command:
mysql> show processlist;
+------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+-----------+---------------+-----------+
| Id | User | Host | db | Command | Time | State | Info | ROWS_SENT | ROWS_EXAMINED | ROWS_READ |
+------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+-----------+---------------+-----------+
| 2 | root | localhost | test | Query | 0 | NULL | SHOW PROCESSLIST | 0 | 0 | 1 |
| 14 | root | localhost | test | Query | 0 | User lock | SELECT GET_LOCK(``t``,1000) | 0 | 0 | 1 |
+------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+-----------+---------------+-----------+
Table PROCESSLIST:
mysql> select * from information_schema.PROCESSLIST;
+------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+----------+---------------+-----------+-----------+
| ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | ROWS_EXAMINED | ROWS_SENT | ROWS_READ |
+------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+----------+---------------+-----------+-----------+
| 14 | root | localhost | test | Query | 0 | User lock | SELECT GET_LOCK(``t``,1000) | 1 | 0 | 0 | 1 |
| 2 | root | localhost | test | Query | 0 | executing | SELECT * from INFORMATION_SCHEMA.PROCESSLIST | 0 | 0 | 0 | 1 |
+------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+----------+---------------+-----------+-----------+
For general inquiries, please send us your question and someone will contact you.
