[MDEV-6981] [PATCH] feature request MASTER_GTID_WAIT status variables Created: 2014-10-30 Updated: 2015-03-17 Resolved: 2015-03-17 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Replication |
| Fix Version/s: | 10.1.4 |
| Type: | Task | Priority: | Major |
| Reporter: | Daniel Black | Assignee: | Kristian Nielsen |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Attachments: |
|
| Description |
|
With MASTER_GTID_WAIT I wouldn't mind a global (and optionally session) indication of:
I'd find this quite useful for general health monitoring of this function, particularly when graphed over time. Thanks for your consideration |
| Comments |
| Comment by Daniel Black [ 2014-11-21 ] | ||||||||
|
attached patch implements three status variables master_gtid_wait_count (# of times called) | ||||||||
| Comment by Daniel Black [ 2014-11-22 ] | ||||||||
|
made output more readable by only replacing $wait_time with MASTER_GTID_WAIT_TIME, leaving expression, and using more accurate labels on output. | ||||||||
| Comment by Kristian Nielsen [ 2014-11-24 ] | ||||||||
|
Looks good. | ||||||||
| Comment by Daniel Black [ 2014-11-24 ] | ||||||||
|
fixed | ||||||||
| Comment by Kristian Nielsen [ 2015-02-04 ] | ||||||||
|
Bummer, I don't know how this has stalled for so long I've pushed it to a feature tree for buildbot testing, once that has run I will push it to 10.1. | ||||||||
| Comment by Kristian Nielsen [ 2015-02-04 ] | ||||||||
|
Ehm, this really does not work:
Those times will fluctuate a lot depending on load on the test machine (as And did you test that the counters are reset to 0 when the test starts, so Also, main.max_statement_time fails (but that's easy to fix). | ||||||||
| Comment by Daniel Black [ 2015-03-11 ] | ||||||||
|
https://github.com/MariaDB/server/pull/21 > Those times will fluctuate a lot depending on load on the test machine (as seen in buildbot). Increased time windows a lot. The immediate case is a event is pushed to the master before master_gtid_wait is called on the slave. The 0.5 case is the timeout occurs on the slave master_gtid_wait. Is there a way to write these sort of test cases? > And did you test that the counters are reset to 0 I'm only looking at the session status variables on a new connection. > Also, main.max_statement_time fails (but that's easy to fix). I don't see that in my patch. | ||||||||
| Comment by Kristian Nielsen [ 2015-03-16 ] | ||||||||
|
I've merged it into 10.1 and pushed to bb-10.1-knielsen for a buidbot run. | ||||||||
| Comment by Kristian Nielsen [ 2015-03-17 ] | ||||||||
|
Pushed to 10.1.4, thanks Daniel! |