The patch adds new table PROCESSLIST in INFORMATION_SCHEMA, with new column (comparing to SHOW PROCESSLIST) - TIME_MS;
mysql> select * from information_schema.PROCESSLIST; +------+-----------+----------------------+--------------------+-------------+------+----------------------------------------------------------------+----------------------------------------------+-------------+ | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | +------+-----------+----------------------+--------------------+-------------+------+----------------------------------------------------------------+----------------------------------------------+-------------+ | 9167 | mailboxer | 192.168.10.164:43683 | board | Sleep | 0 | | NULL | 104.796 | | 9166 | mailboxer | 192.168.10.163:40598 | board | Sleep | 0 | | NULL | 895.226 | | 9163 | mailboxer | 192.168.10.166:55208 | board | Sleep | 0 | | NULL | 2.092 | | 9162 | mailboxer | 192.168.10.163:40341 | board | Sleep | 1 | | NULL | 1880.647 | | 9152 | mailboxer | 192.168.10.163:39837 | board | Sleep | 2 | | NULL | 2389.434 | | 9147 | mailboxer | 192.168.10.164:43550 | board | Sleep | 0 | | NULL | 11.706 | | 9146 | mailboxer | localhost | test | Sleep | 0 | | NULL | 1.756 | | 9135 | mailboxer | 192.168.10.161:50824 | board | Sleep | 1 | | NULL | 1626.042 | | 128 | root | localhost | information_schema | Query | 0 | executing | select * from information_schema.PROCESSLIST | 0.313 | | 53 | replicant | 192.168.10.176:53373 | NULL | Binlog Dump | 1808 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | 1808291.785 | +------+-----------+----------------------+--------------------+-------------+------+----------------------------------------------------------------+----------------------------------------------+-------------+
The TIME_MS is equal to TIME, the difference it shows value in milliseconds with fractions
Discussion