Mysql extend not pulling data to graph

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[UPDATE applications set app_state=?,app_status=?,timestamp=NOW(),app_state_prev=? WHERE app_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 :frowning: (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