3 years ago
Who published MysqlReplicationLag-
Who published MysqlReplicationLag- ?
Not sure if its just something in my instance or something I should report....?
I had some issues with it, and not sure if its a LogicMonitor provided DataSource.
- The query used a SQL function name (LAG) for a variable/column
-
select time_to_sec(timediff(UTC_TIMESTAMP(), ts)) as lag from heartbeat where id=1;
LAG is a function so this just gets a 1064 error. I modified lag to rep_lag and had the Datapoint pick that upselect time_to_sec(timediff(UTC_TIMESTAMP(), ts)) as rep_lag from heartbeat where id=1;
This now works for me.