[MDEV-32446] Add GTIDs_behind_master to Show-Slave-Status .. Created: 2023-10-11 Updated: 2023-10-30 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Replication |
| Fix Version/s: | 11.5 |
| Type: | Task | Priority: | Major |
| Reporter: | Andrei Elkin | Assignee: | Brandon Nesterenko |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | None | ||
| Description |
|
as an alternative or functional replacement to Seconds_behind_master. The request comes from salle of MariaDB support. |
| Comments |
| Comment by Alexander Keremidarski [ 2023-10-11 ] |
|
In my humble opinion a message like: "N transactions behind the master" is much better indicator than Seconds_behind_master. 1000 seconds behind can mean single long running transaction whereas 15 seconds behind can mean 40 transactions behind. A DBA could be concerned more about slave lag of 40 transactions than about 1 transaction lag. This will also allow for better alerts by monitoring tools. |