Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
-
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
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link | This issue relates to MDEV-11703 [ MDEV-11703 ] |
| Remote Link | This issue links to "#1680803 pt-mysql-summary does not work with MariaDB 10.2.5 (Web Link)" [ 27956 ] |
| Link |
This issue relates to |
| Assignee | Marko Mäkelä [ marko ] | Vladislav Vaintroub [ wlad ] |
| Fix Version/s | 10.5.1 [ 24029 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 80379 ] | MariaDB v4 [ 151972 ] |