Bug #110683 Multi-threaded slave statistics output is incorrect
Submitted: 13 Apr 2023 13:21 Modified: 14 Apr 2023 7:52
Reporter: IGG t Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.7, 8.0 OS:Any
Assigned to: CPU Architecture:Any

[13 Apr 2023 13:21] IGG t
Description:
When using multi-threaded replication, the statistics are output to the error log every 120+ seconds. The format is similar to:

Apr 13 00:12:02 dbname mysqld[519]: 2023-04-12T23:12:02.476345Z 35394324 [Note] [MY-010559] [Repl] Multi-threaded slave statistics for channel '': seconds elapsed = 361; events assigned = 5529601; worker queues filled over overrun level = 0;
waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 5126840752000 waited (count) when Workers occupied = 488 waited when Workers occupied = 670893000

Each if the fields is separated with a ";" apart from the last few:

waited at clock conflicts = 5126840752000 [no semicolon] waited (count) when Workers occupied = 488 [no semicolon] waited when Workers occupied = 670893000

How to repeat:
set up Multi-threaded replication and check the logs

Suggested fix:
Ideally each field should be separated with a semicolon to make them all consistent, and therefore easier for monitoring purposes.
[14 Apr 2023 7:52] MySQL Verification Team
Hello!

Thank you for the report and feedback.

Thanks,
Umesh