Usage Data

View: New views
6 Messages — Rating Filter:   Alert me  

Usage Data

by Michael-431 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Cacti's web site they state that the data is stored in mysql.
Exactly what are they storing in mysql.  Is it usage data?
And if so can it be used to for 95th percentile billing.


--
Regards,
Michael Di Martino
516 508 6030
mdm100@...

_______________________________________________
rrd-users mailing list
rrd-users@...
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users

Re: Usage Data

by PAUL WILLIAMSON-6 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Configuration data.  Usage data is stored in RRDs.

>>> Michael <mdm100@...> 7/9/2008 4:12 PM >>>
On Cacti's web site they state that the data is stored in mysql.
Exactly what are they storing in mysql.  Is it usage data?
And if so can it be used to for 95th percentile billing.


--
Regards,
Michael Di Martino
516 508 6030
mdm100@...

_______________________________________________
rrd-users mailing list
rrd-users@...
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users


_______________________________________________
rrd-users mailing list
rrd-users@...
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users

Re: Usage Data

by nate-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Michael wrote:
> On Cacti's web site they state that the data is stored in mysql.
> Exactly what are they storing in mysql.  Is it usage data?
> And if so can it be used to for 95th percentile billing.
>

I setup RTG for 95th percentile stuff, from my searches it seemed that
was the most respected tool for measuring bandwidth in 95th percentile
form.

RTG stores data in MySQL and comes with several simple scripts to query
the DB.

[nagios@pd1-exmon01:/usr/local/rtg/bin]$ ./95.pl Uplink `date --date="-1day"
+%x+%H:%M` `date +%x+%H:%M`
Uplink Traffic
Period: [07/08/2008 13:37:00 to 07/09/2008 13:37:00]

                            RateIn   RateOut    MaxIn   MaxOut   95% In  95%
Out
Connection                    Mbps      Mbps     Mbps     Mbps     Mbps    
Mbps
--------------------------------------------------------------------------------
GigabitEther pd1-brt01.pd   178.88    113.22   259.75   164.69   248.72  
160.26
GigabitEther pd1-brt02.pd   117.66     66.05   233.61   129.18   214.92  
115.85
GigabitEther pd2-brt01.pd   164.83    147.81   271.18   260.92   250.70  
249.62
GigabitEther pd2-brt02.pd    77.98     50.93   128.05    82.22   117.84  
76.62

Total:                      539.35    378.01   892.59   637.01   832.18  
602.35

RTG is available at http://rtg.sourceforge.net/ though it hasn't been
updated in a while. I was unable to get it to compile on a 64-bit system.

I also use cacti extensively, though I was unable to come up with a good
way to alert based on 95% for traffic using cacti which is why I went to
RTG.

Not to be confused with MRTG, RTG is a different project, though
inspired by MRTG I believe.

nate


_______________________________________________
rrd-users mailing list
rrd-users@...
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users

Re: Usage Data

by Michael Di Martino-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

-----Original Message-----
From: rrd-users-bounces@... [mailto:rrd-users-bounces@...] On Behalf Of nate
Sent: Wednesday, July 09, 2008 4:38 PM
To: rrd-users@...
Subject: Re: [rrd-users] Usage Data

Michael wrote:
> On Cacti's web site they state that the data is stored in mysql.
> Exactly what are they storing in mysql.  Is it usage data?
> And if so can it be used to for 95th percentile billing.
>
____________________________________________________________________________

>> I setup RTG for 95th percentile stuff, from my searches it seemed that
>> was the most respected tool for measuring bandwidth in 95th percentile
>> form.........

>> nate

____________________________________________________________________________

Nate
I have RTG install and I am having trouble poling snmp v1 devices.
Do you know how to you get RTG to pol v2c and v1 devices?



_______________________________________________
rrd-users mailing list
rrd-users@...
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users

_______________________________________________
rrd-users mailing list
rrd-users@...
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users

Re: Usage Data

by Mark Duling :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Re: [rrd-users] Usage Data Cacti stores only configuration data in mysql.  Performance values are stored in rrdtool files.

Mark


On 7/9/08 1:12 PM, "Michael" <mdm100@...> wrote:

On Cacti's web site they state that the data is stored in mysql.
Exactly what are they storing in mysql.  Is it usage data?
And if so can it be used to for 95th percentile billing.


--
Regards,
Michael Di Martino
516 508 6030
mdm100@...

_______________________________________________
rrd-users mailing list
rrd-users@...
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users


_______________________________________________
rrd-users mailing list
rrd-users@...
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users

Re: Usage Data

by nate-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Michael Di Martino wrote:

> I have RTG install and I am having trouble poling snmp v1 devices.
> Do you know how to you get RTG to pol v2c and v1 devices?

My RTG is polling SNMP v1 exclusively. I tried polling SNMP v2c
but I didn't see any difference in the output for the devices I
am monitoring. I also was not able to poll any 64-bit counters
either.

I suspect what you might need to do is have two separate RTG
installations, since the SNMP version seems to be defined in
the common configuration file. One install for SNMPv1 and
the other for SNMPv2.

nate

_______________________________________________
rrd-users mailing list
rrd-users@...
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
LightInTheBox - Buy quality products at wholesale price