Who published MysqlReplicationLag- | Product Discussions

Justin_Cooksey · 2022-11-09T02:59:51Z

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 up select time_to_sec(timediff(UTC_TIMESTAMP(), ts)) as rep_lag from heartbeat where id=1; This now works for me.

MoreDiscussions

Who published MysqlReplicationLag- | Product Discussions | LogicMonitor Community