[MDEV-7898] Add GTID_Slave_Pos to SHOW SLAVE STATUS Created: 2015-04-02  Updated: 2015-04-02

Status: Open
Project: MariaDB Server
Component/s: Replication
Affects Version/s: 10.0.17
Fix Version/s: 10.1

Type: Bug Priority: Trivial
Reporter: Guillaume Lefranc Assignee: Kristian Nielsen
Resolution: Unresolved Votes: 0
Labels: None


 Description   

I understand that it is possible to get gtid_slave_pos from the variables, however it would be more convenient to have them all in one place. SHOW SLAVE STATUS displays GTID_IO_POS already, and GTID_Slave_Pos is in SHOW ALL SLAVES STATUS. Why it isn't in the regular SHOW SLAVE STATUS display is out of my knowledge...

Thanks
-GL



 Comments   
Comment by Elena Stepanova [ 2015-04-02 ]

I think it's because GTID_Slave_pos is an essentially overall characteristic, it shows the composite position for all domains. If you put it in a single slave status, it might contain information that has nothing to do with this particular master connection.

Of course, it also means that for non-multisource setups, which are probably the vast majority, SHOW SLAVE STATUS also won't show the value, even though it would be perfectly suitable there.

I'll leave it to knielsen to decide what to do with this request.

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