Mysql extend not pulling data to graph

snmp
Tags: #<Tag:0x00007fe22638a878>

#1

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.


#2

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


#4

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]


#5

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)


#6

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


#7

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)


#8

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.


#9

thats the poller

but the rrd, is that readable atm?


#10

I assume it is as all my other graphs are 100%

How will I be able to test?


#11

if u click the graph,
i can see show rrd command

run this in cli