I'm sure I'm just missing a config directive somewhere, but I can't seem to figure out what. I have a MRTG graph I have set up to show query counts on my database. I reset the stats after each time I pull them, so I have the MRTG Options gauge directive specified. On a test database with no active users, I then ran twelve queries, and verified that the script I am running to get the data showed 12 as the output on the first line. However, when MRTG next ran, it showed a last value of only 4 rather than the 12 my script is returning. To make it even more odd, I've sometimes seen values of 1.6 or other non-integer numbers, even though my script only returns integer values. What am I missing? My config is shown below.

On a mostly unrelated note, is there any way to not have a MaxBytes directive? Since I am displaying a query count, it is essentially unlimited, although obviously I could just use some value that is so ridiculously high it is unlikely to ever be exceeded.

Thanks!

WorkDir: /var/www/mrtg
LogFormat: rrdtool
PathAdd: /usr/local/bin
Interval: 1

Target[fai-dbs1-flightlog-queries]: `/usr/local/bin/pg_stats.py <required arguments>`
Title[fai-dbs1-flightlog-queries]:fai-dbs1 FlightLogs Queries
PageTop[fai-dbs1-flightlog-queries]: <h1>fai-dbs1 FlightLogs Queries</h1>
Options[fai-dbs1-flightlog-queries]: integer growright gauge noi
MaxBytes[fai-dbs1-flightlog-queries]: 5000
LegendI[fai-dbs1-flightlog-queries]:&nbsp;   
LegendO[fai-dbs1-flightlog-queries]:&nbsp;Count:
Legend1[fai-dbs1-flightlog-queries]:&nbsp;
Legend2[fai-dbs1-flightlog-queries]:Number of queries
YLegend[fai-dbs1-flightlog-queries]:count
-----------------------------------------------
Israel Brewster
Systems Analyst II
Ravn Alaska
5245 Airport Industrial Rd
Fairbanks, AK 99709
(907) 450-7293
-----------------------------------------------


BEGIN:VCARD
VERSION:3.0
N:Brewster;Israel;;;
FN:Israel Brewster
ORG:Frontier Flying Service;MIS
TITLE:PC Support Tech II
EMAIL;type=INTERNET;type=WORK;type=pref:[email protected]
TEL;type=WORK;type=pref:907-450-7293
item1.ADR;type=WORK;type=pref:;;5245 Airport Industrial Wy;Fairbanks;AK;99701;
item1.X-ABADR:us
CATEGORIES:General
X-ABUID:36305438-95EA-4410-91AB-45D16CABCDDC\:ABPerson
END:VCARD

_______________________________________________
mrtg mailing list
[email protected]
https://lists.oetiker.ch/cgi-bin/listinfo/mrtg

Reply via email to