Hi guys,
Why is it that my extend only logs for 10-15 min and then stops?
any idea as to where I can check what the issue is.
Hi guys,
Why is it that my extend only logs for 10-15 min and then stops?
any idea as to where I can check what the issue is.
did u change someting in the mysql ?
user/pass
allow only localhost or 127.0.0.1
etc etc
it cant be “it yust stops”. normaly some1 needs to do someting to the premissions.
or you, or some1 from outside if u are not protected.
so look (errer) logs of the mysql/mariadb
Poller does create the rrd file but it doesn’t seem to pull the data to the graphs
BTW this is LibreNMS localhost.
mysqlRRD[create /mnt/data-01/rrd/172.16.30.143/app-mysql-29.rrd --step 300 DS:IDBLBSe:GAUGE:600:0:125000000000 DS:IBLFh:DERIVE:600:0:125000000000 DS:IBLWn:DERIVE:600:0:125000000000 DS:SRows:DERIVE:600:0:125000000000 DS:SRange:DERIVE:600:0:125000000000 DS:SMPs:DERIVE:600:0:125000000000 DS:SScan:DERIVE:600:0:125000000000 DS:IBIRd:DERIVE:600:0:125000000000 DS:IBIWr:DERIVE:600:0:125000000000 DS:IBILg:DERIVE:600:0:125000000000 DS:IBIFSc:DERIVE:600:0:125000000000 DS:IDBRDd:DERIVE:600:0:125000000000 DS:IDBRId:DERIVE:600:0:125000000000 DS:IDBRRd:DERIVE:600:0:125000000000 DS:IDBRUd:DERIVE:600:0:125000000000 DS:IBRd:DERIVE:600:0:125000000000 DS:IBCd:DERIVE:600:0:125000000000 DS:IBWr:DERIVE:600:0:125000000000 DS:TLIe:DERIVE:600:0:125000000000 DS:TLWd:DERIVE:600:0:125000000000 DS:IBPse:GAUGE:600:0:125000000000 DS:IBPDBp:GAUGE:600:0:125000000000 DS:IBPFe:GAUGE:600:0:125000000000 DS:IBPMps:GAUGE:600:0:125000000000 DS:TOC:GAUGE:600:0:125000000000 DS:OFs:GAUGE:600:0:125000000000 DS:OTs:GAUGE:600:0:125000000000 DS:OdTs:COUNTER:600:0:125000000000 DS:IBSRs:DERIVE:600:0:125000000000 DS:IBSWs:DERIVE:600:0:125000000000 DS:IBOWs:DERIVE:600:0:125000000000 DS:QCs:GAUGE:600:0:125000000000 DS:QCeFy:GAUGE:600:0:125000000000 DS:MaCs:GAUGE:600:0:125000000000 DS:MUCs:GAUGE:600:0:125000000000 DS:ACs:DERIVE:600:0:125000000000 DS:AdCs:DERIVE:600:0:125000000000 DS:TCd:GAUGE:600:0:125000000000 DS:Cs:DERIVE:600:0:125000000000 DS:IBTNx:DERIVE:600:0:125000000000 DS:KRRs:DERIVE:600:0:125000000000 DS:KRs:DERIVE:600:0:125000000000 DS:KWR:DERIVE:600:0:125000000000 DS:KWs:DERIVE:600:0:125000000000 DS:QCQICe:DERIVE:600:0:125000000000 DS:QCHs:DERIVE:600:0:125000000000 DS:QCIs:DERIVE:600:0:125000000000 DS:QCNCd:DERIVE:600:0:125000000000 DS:QCLMPs:DERIVE:600:0:125000000000 DS:CTMPDTs:DERIVE:600:0:125000000000 DS:CTMPTs:DERIVE:600:0:125000000000 DS:CTMPFs:DERIVE:600:0:125000000000 DS:IBIIs:DERIVE:600:0:125000000000 DS:IBIMRd:DERIVE:600:0:125000000000 DS:IBIMs:DERIVE:600:0:125000000000 DS:IBILog:DERIVE:600:0:125000000000 DS:IBISc:DERIVE:600:0:125000000000 DS:IBIFLg:DERIVE:600:0:125000000000 DS:IBFBl:DERIVE:600:0:125000000000 DS:IBIIAo:DERIVE:600:0:125000000000 DS:IBIAd:DERIVE:600:0:125000000000 DS:IBIAe:DERIVE:600:0:125000000000 DS:SFJn:DERIVE:600:0:125000000000 DS:SFRJn:DERIVE:600:0:125000000000 DS:SRe:DERIVE:600:0:125000000000 DS:SRCk:DERIVE:600:0:125000000000 DS:SSn:DERIVE:600:0:125000000000 DS:SQs:DERIVE:600:0:125000000000 DS:BRd:DERIVE:600:0:125000000000 DS:BSt:DERIVE:600:0:125000000000 DS:CDe:DERIVE:600:0:125000000000 DS:CIt:DERIVE:600:0:125000000000 DS:CISt:DERIVE:600:0:125000000000 DS:CLd:DERIVE:600:0:125000000000 DS:CRe:DERIVE:600:0:125000000000 DS:CRSt:DERIVE:600:0:125000000000 DS:CSt:DERIVE:600:0:125000000000 DS:CUe:DERIVE:600:0:125000000000 DS:CUMi:DERIVE:600:0:125000000000 RRA:AVERAGE:0.5:1:2016 RRA:AVERAGE:0.5:6:1440 RRA:AVERAGE:0.5:24:1440 RRA:AVERAGE:0.5:288:1440 RRA:MIN:0.5:1:720 RRA:MIN:0.5:6:1440 RRA:MIN:0.5:24:775 RRA:MIN:0.5:288:797 RRA:MAX:0.5:1:720 RRA:MAX:0.5:6:1440 RRA:MAX:0.5:24:775 RRA:MAX:0.5:288:797 RRA:LAST:0.5:1:1440 ]
RRD[update /mnt/data-01/rrd/172.16.30.143/app-mysql-29.rrd N:16777216:U:U:49703:2621:0:1896:U:U:U:127781:1662:5106:15036100:111229:2975:70:72839:249675:0:8191:3045:4811:430:2000:55:207:213:0:0:0:16777216:12850552:151:33:0:0:18:3269:U:0:0:0:0:2086:73545:84028:137:0:385:2573:6:U:U:U:U:U:U:0:U:0:0:17:0:4023:0:3666:0:100563206:594885952:802:3789:0:0:0:0:159495:111351:0]
RRD[create /mnt/data-01/rrd/172.16.30.143/app-mysql-29-status.rrd --step 300 DS:d2:GAUGE:600:0:125000000000 DS:d3:GAUGE:600:0:125000000000 DS:d4:GAUGE:600:0:125000000000 DS:d5:GAUGE:600:0:125000000000 DS:d6:GAUGE:600:0:125000000000 DS:d7:GAUGE:600:0:125000000000 DS:d8:GAUGE:600:0:125000000000 DS:d9:GAUGE:600:0:125000000000 DS:da:GAUGE:600:0:125000000000 DS:db:GAUGE:600:0:125000000000 DS:dc:GAUGE:600:0:125000000000 DS:dd:GAUGE:600:0:125000000000 DS:de:GAUGE:600:0:125000000000 DS:df:GAUGE:600:0:125000000000 DS:dg:GAUGE:600:0:125000000000 DS:dh:GAUGE:600:0:125000000000 RRA:AVERAGE:0.5:1:2016 RRA:AVERAGE:0.5:6:1440 RRA:AVERAGE:0.5:24:1440 RRA:AVERAGE:0.5:288:1440 RRA:MIN:0.5:1:720 RRA:MIN:0.5:6:1440 RRA:MIN:0.5:24:775 RRA:MIN:0.5:288:797 RRA:MAX:0.5:1:720 RRA:MAX:0.5:6:1440 RRA:MAX:0.5:24:775 RRA:MAX:0.5:288:797 RRA:LAST:0.5:1:1440 ]
RRD[update /mnt/data-01/rrd/172.16.30.143/app-mysql-29-status.rrd N:0:0:0:0:1:0:0:0:0:0:0:0:0:0:17:0]
SQL[UPDATEapplications
setapp_state
=?,app_status
=?,timestamp
=NOW(),app_state_prev
=? WHEREapp_id
= ? [“OK”,“”,“UNKNOWN”,29] 6.68ms]SQL[SELECT * FROM
application_metrics
WHERE app_id=? [29] 0.54ms]: SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IDBLBSe”,“value”:16777216} 1.82ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBLFh”,“value”:“U”} 1.05ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBLWn”,“value”:“U”} 2.22ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“SRows”,“value”:49703} 2.37ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“SRange”,“value”:2621} 2.21ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“SMPs”,“value”:0} 1.59ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“SScan”,“value”:1896} 2.09ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBIRd”,“value”:“U”} 1.35ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBIWr”,“value”:“U”} 3.76ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBILg”,“value”:“U”} 2.01ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBIFSc”,“value”:127781} 0.73ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IDBRDd”,“value”:1662} 2.74ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IDBRId”,“value”:5106} 0.72ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IDBRRd”,“value”:15036100} 0.76ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IDBRUd”,“value”:111229} 2.54ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBRd”,“value”:2975} 2.13ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBCd”,“value”:70} 3.11ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBWr”,“value”:72839} 0.78ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“TLIe”,“value”:249675} 0.79ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“TLWd”,“value”:0} 0.72ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBPse”,“value”:8191} 1.79ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBPDBp”,“value”:3045} 0.72ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBPFe”,“value”:4811} 0.97ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBPMps”,“value”:430} 1.73ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“TOC”,“value”:2000} 0.7ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“OFs”,“value”:55} 0.7ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“OTs”,“value”:207} 1.75ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“OdTs”,“value”:213} 0.73ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBSRs”,“value”:0} 0.72ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBSWs”,“value”:0} 0.67ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBOWs”,“value”:0} 1.73ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“QCs”,“value”:16777216} 0.68ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“QCeFy”,“value”:12850552} 0.77ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“MaCs”,“value”:151} 1.72ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“MUCs”,“value”:33} 0.69ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“ACs”,“value”:0} 0.68ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“AdCs”,“value”:0} 0.69ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“TCd”,“value”:18} 1.78ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“Cs”,“value”:3269} 0.71ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBTNx”,“value”:“U”} 0.75ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“KRRs”,“value”:0} 1.76ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“KRs”,“value”:0} 0.69ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“KWR”,“value”:0} 0.68ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“KWs”,“value”:0} 1.16ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“QCQICe”,“value”:2086} 1.69ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“QCHs”,“value”:73545} 0.69ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“QCIs”,“value”:84028} 0.73ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“QCNCd”,“value”:137} 1.86ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“QCLMPs”,“value”:0} 0.69ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“CTMPDTs”,“value”:385} 0.74ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“CTMPTs”,“value”:2573} 1.77ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“CTMPFs”,“value”:6} 0.71ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBIIs”,“value”:“U”} 0.72ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBIMRd”,“value”:“U”} 1.81ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBIMs”,“value”:“U”} 0.69ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBILog”,“value”:“U”} 0.7ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBISc”,“value”:“U”} 0.73ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBIFLg”,“value”:“U”} 1.77ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBFBl”,“value”:0} 0.69ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBIIAo”,“value”:“U”} 0.9ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBIAd”,“value”:0} 1.83ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“IBIAe”,“value”:0} 0.69ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“SFJn”,“value”:17} 0.73ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“SFRJn”,“value”:0} 1.78ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“SRe”,“value”:4023} 0.75ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“SRCk”,“value”:0} 0.74ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“SSn”,“value”:3666} 0.79ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“SQs”,“value”:0} 1.72ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“BRd”,“value”:100563206} 0.69ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“BSt”,“value”:594885952} 0.74ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“CDe”,“value”:802} 1.73ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“CIt”,“value”:3789} 0.76ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“CISt”,“value”:0} 0.74ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“CLd”,“value”:0} 0.75ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“CRe”,“value”:0} 1.79ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“CRSt”,“value”:0} 0.75ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“CSt”,“value”:159495} 0.71ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“CUe”,“value”:111351} 2.26ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“CUMi”,“value”:0} 0.69ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“State_closing_tables”,“value”:0} 0.76ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“State_copying_to_tmp_table”,“value”:0} 1.77ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“State_end”,“value”:0} 0.7ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“State_freeing_items”,“value”:0} 0.74ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“State_init”,“value”:1} 1.75ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“State_locked”,“value”:0} 0.7ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“State_login”,“value”:0} 0.71ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“State_preparing”,“value”:0} 0.69ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“State_reading_from_net”,“value”:0} 1.74ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“State_sending_data”,“value”:0} 0.69ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“State_sorting_result”,“value”:0} 0.72ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“State_statistics”,“value”:0} 1.77ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“State_updating”,“value”:0} 0.73ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“State_writing_to_net”,“value”:0} 0.72ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“State_none”,“value”:17} 0.67ms]+SQL[INSERT IGNORE INTO
application_metrics
(app_id
,metric
,value
) VALUES (:app_id,:metric,:value) {“app_id”:29,“metric”:“State_other”,“value”:0} 1.76ms]
well my update on mysql (SNMP extend)
starts like:
RRD[update localhost/app-mysql-2.rrd
yours RRD[update /mnt/data-01/rrd/172.16.30.143/app-mysql-29.rrd
So thats not localhost imo + other then standaart instal. (or run as root?)
My guess is to look at RRD command line (if u click on the graph )
or look where its stored…
So for this i cant help you , sorry (but maybe some1 else)
its Localhost, this is just the directory my RRD files are writen to.
/mnt/data-01/rrd/xx.xx.xx.xx/app-mysql-29.rrd
Is the rrd readable in command line / are the counters correct?
Thats all i can think off
Else… sorry i cant help (Mut again maybe some1 else)
it is it pulls the data when I run
/etc/snmp/mysql
gives me the following data.
a0:0
a1:0
a2:0
a3:0
a4:-1
a5:-1
a6:-1
a7:-1
a8:0
a9:0
aa:8191
ab:2424
etc
my issue is that it pulls the data for 10 min then stops for some reason my polling is fine it polls everything.
thats the poller
but the rrd, is that readable atm?
I assume it is as all my other graphs are 100%
How will I be able to test?
if u click the graph,
i can see show rrd command
run this in cli