[MDEV-23590] P_S.replication_applier_status_by_worker table is missing Created: 2020-08-26  Updated: 2020-08-27  Resolved: 2020-08-27

Status: Closed
Project: MariaDB Server
Component/s: Performance Schema, Replication
Affects Version/s: 10.5.6
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Valerii Kravchuk Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
PartOf
is part of MDEV-16437 merge 5.7 P_S replication instrumenta... Closed

 Description   

It seems worker threads of parallel replication are NOT instrumented in MariaDB 10.5's Performance Schema. We see thew following 4 replication tables:

MariaDB [performance_schema]> show tables like 'replication%';
 
+---------------------------------------------+
 
| Tables_in_performance_schema (replication%) |
 
+---------------------------------------------+
 
| replication_applier_configuration           |
 
| replication_applier_status                  |
 
| replication_applier_status_by_coordinator   |
 
| replication_connection_configuration        |
 
+---------------------------------------------+
 
4 rows in set (0,001 sec)
 
 
 
MariaDB [performance_schema]> select version();
 
+----------------+
 
| version()      |
 
+----------------+
 
| 10.5.6-MariaDB |
 
+----------------+
 
1 row in set (0,038 sec)

and for me it does not make se4nse to instrument coordinator thread without instrumenting worker threads. MySQL 5.7 has the replication_applier_status_by_worker table for this (https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-by-worker-table.html), and it should be added to MariaDB.

 Comments   
Comment by Sergei Golubchik [ 2020-08-27 ]

This will be done in MDEV-16437

Generated at Thu Feb 08 09:23:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.