Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL), 10.4(EOL)
-
Linux, n.a.
Description
SHOW GLOBAL STATUS LIKE 'threads_running' was a good indicator for the current running workload in a database.
Sine MariaDB 10.3 it is showing higher values than before (MariaDB 10.2 and lower and competitive products).
10.2.14-MariaDB-log MariaDB Server
SELECT id, user, command, state FROM information_schema.processlist; |
+----+-------------+-------------+------------------------------------------------------------------+ |
| id | user | command | state | |
+----+-------------+-------------+------------------------------------------------------------------+ |
| 21 | root | Query | Filling schema table | |
| 10 | replication | Binlog Dump | Master has sent all binlog to slave; waiting for binlog to be up | |
| 5 | system user | Daemon | InnoDB shutdown handler | |
| 4 | system user | Daemon | InnoDB purge worker | |
| 2 | system user | Daemon | InnoDB purge worker | |
| 1 | system user | Daemon | InnoDB purge worker | |
| 3 | system user | Daemon | InnoDB purge coordinator | |
+----+-------------+-------------+------------------------------------------------------------------+ |
7 rows in set (0.00 sec) |
SHOW GLOBAL STATUS LIKE 'threads_running'; |
+-----------------+-------+ |
| Variable_name | Value |
|
+-----------------+-------+ |
| Threads_running | 2 |
|
+-----------------+-------+ |
10.3.12-MariaDB-log MariaDB Server
SELECT id, user, command, state FROM information_schema.processlist; |
+----+-------------+---------+--------------------------+ |
| id | user | command | state | |
+----+-------------+---------+--------------------------+ |
| 10 | root | Query | Filling schema table | |
| 5 | system user | Daemon | InnoDB shutdown handler | |
| 2 | system user | Daemon | InnoDB purge coordinator | |
| 4 | system user | Daemon | InnoDB purge worker | |
| 3 | system user | Daemon | InnoDB purge worker | |
| 1 | system user | Daemon | InnoDB purge worker | |
+----+-------------+---------+--------------------------+ |
6 rows in set (0.001 sec) |
SHOW GLOBAL STATUS LIKE 'threads_running'; |
+-----------------+-------+ |
| Variable_name | Value |
|
+-----------------+-------+ |
| Threads_running | 6 |
|
+-----------------+-------+ |
It seems like now it is showing all Threads from Processlist including Daemon threads. This was not the case before. The Daemon threads are currently not doing anything on my system so they should not be counted in.
Impact: This could influence/confuse all monitoring solutions for MariaDB and will show a virtual higher workload compared to previous versions (bad image) and pseudo-require more CPU resource allocation for newer releases.
Possibly was introduced with this fix: https://jira.mariadb.org/browse/MDEV-14505
Attachments
Issue Links
- blocks
-
-
- Closed
-
- relates to
-
MDEV-16264 Implement a common work queue for InnoDB background tasks
-
- Closed
-