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) Email Updates:
Status: Verified Impact on me:
None 
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