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
-
<span class="kwd">select</span><span class="pln"> time_to_sec</span><span class="pun">(</span><span class="pln">timediff</span><span class="pun">(</span><span class="pln">UTC_TIMESTAMP</span><span class="pun">(),</span><span class="pln"> ts</span><span class="pun">))</span><span class="pln"> </span><span class="kwd">as</span><span class="pln"> lag </span><span class="kwd">from</span><span class="pln"> heartbeat </span><span class="kwd">where</span><span class="pln"> id</span><span class="pun">=</span><span class="lit">1</span><span class="pun">;</span>
LAG is a function so this just gets a 1064 error. I modified lag to rep_lag and had the Datapoint pick that up
<span class="kwd">select</span><span class="pln"> time_to_sec</span><span class="pun">(</span><span class="pln">timediff</span><span class="pun">(</span><span class="pln">UTC_TIMESTAMP</span><span class="pun">(),</span><span class="pln"> ts</span><span class="pun">))</span><span class="pln"> </span><span class="kwd">as</span><span class="pln"> rep_lag </span><span class="kwd">from</span><span class="pln"> heartbeat </span><span class="kwd">where</span><span class="pln"> id</span><span class="pun">=</span><span class="lit">1</span><span class="pun">;</span>
This now works for me.
LM User
·3 years agoIn Settings >> DataSources, if you search for and select that DS, you should see at the top that the author is LogicMonitor v1.2, with locator RNHL7J.