Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2
-
None
Description
MariaDB [(none)]> show processlist;
|
+----+-------------+-----------------+------+---------+------+--------------------------+------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+----+-------------+-----------------+------+---------+------+--------------------------+------------------+----------+
|
| 1 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 2 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 4 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 |
|
| 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 |
|
| 9 | root | localhost:55630 | NULL | Query | 0 | init | show processlist | 0.000 |
|
| 10 | root | localhost:55632 | NULL | Sleep | 12 | | NULL | 0.000 |
|
+----+-------------+-----------------+------+---------+------+--------------------------+------------------+----------+
|
Time NULL instead of a numeric value breaks third-party tools, such as pt* toolkit, see https://bugs.launchpad.net/percona-toolkit/+bug/1680803 . Every individual tool should be easy to fix, but it doesn't make sense to bother, better just to show there something tool-friendly.
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST already shows zeros:
*************************** 7. row ***************************
|
ID: 1
|
USER: system user
|
HOST:
|
DB: NULL
|
COMMAND: Daemon
|
TIME: 0
|
STATE: InnoDB purge worker
|
INFO: NULL
|
TIME_MS: 0.000
|
STAGE: 0
|
MAX_STAGE: 0
|
PROGRESS: 0.000
|
MEMORY_USED: 24592
|
EXAMINED_ROWS: 0
|
QUERY_ID: 0
|
INFO_BINARY: NULL
|
TID: 11765
|
7 rows in set (0.01 sec)
|
Attachments
Issue Links
- relates to
-
-
- Stalled
-
-
MDEV-16264 Implement a common work queue for InnoDB background tasks
-
- Closed
-
- links to