MySQL Bugs: #34900: Add Global Status on the MEM replication page to show all Seconds Behind Master

Bug #34900	Add Global Status on the MEM replication page to show all Seconds Behind Master
Submitted:	27 Feb 2008 18:20	Modified:	30 Jun 2009 14:09
Reporter:	Chris Calender	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Enterprise Monitor: Server	Severity:	S4 (Feature request)
Version:	2.0.5.7153	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	MySQL Enterprise Monitor, Seconds Behind Master

Description:
If you have many replication trees, when the trees are not opened, one cannot see the "Time Behind" (or Seconds Behind Master).  With this many replication trees, it becomes unmanageable to open each tree every time to check these values.

It would be nice if there was an easier way to detect and see this information rather than having to open each tree first.

For example, if we could add a global status for this on the MEM replication page, it would save a good amount of time, and make this really easy to check.  

For instance, we could output the following:

Servers Type Slave IO Slave SQL Time Behind Binlog Binlog Pos Master Binlog Master Binlog Pos Last Error 
GLOBAL-REP (2) TREE Running Running __2servers_critical_behind__ rename group

If we had something like the above, one could easily see if the status of the replication of all trees is okay or not.

How to repeat:
N/A

Suggested fix:
See above.