Bug #78068 replication_* tables miss information about binary log position and other

• Submitted: 14 Aug 2015 12:21
• Modified: 15 Aug 2015 15:03
• Reporter: Sveta Smirnova (OCA)
• Status: Verified
• Category: MySQL Server: Performance Schema
• Severity: S3 (Non-critical)
• Version: 5.7.8
• OS: Any
• Assigned to: Marc ALFF
• CPU Architecture: Any

[14 Aug 2015 12:21] Sveta Smirnova

Description:
Performance Schema has replication_* tables which contain almost all information from SHOW SLAVE STATUS. But they miss very important ones:

- read and exec binary log name
- read and exec binary log position
- read and exec relay log position
- read and exec relay log name
- GTID executed unless multithreaded slave used

This make these tables partially useless

How to repeat:
See description

Suggested fix:
Add all information which SHOW SLAVE STATUS provides, make full replacement of SHOW SLAVE STATUS: it is mush easier to work with tables than parse SHOW output.

[15 Aug 2015 15:03] MySQL Verification Team

Hello Sveta,

Thank you for the reasonable feature request!

Regards,
Umesh