[mrtg] Re: mrtgsql - a MRTG to SQL logging and reporting tool

[Tobias Oetiker]

Today Marc Bilodeau wrote:

> Good question tobi, at Somix our denika/webnm products write the polled data
> to both the RRD files and the MySQL back-end. We believe that users should
> have a quick reference for daily, weekly, monthly, and yearly data. However,
> if the user needs to create a report based on 5 minute samples between 8am
> and 5pm for Tuesday, Thursday, and Friday on the week of October 23 they can
> with the stored data. Some would argue by increasing the amount of data that
> can be stored in the rrd file would do the trick. However, many other tools
> out there can take advantage of the database via ODBC or a direct
> connection.

Hi Marc,

Yep, that seems like a sensible thing .... I would assume though
that in a setup with MANY datasources, that mysql may probably not
be able to keep up or fill up quickly if no data is deleted ...

have you done any tests in this direction ? mysql vs rrd
performance?

cheers
tobi


-- 
 ______    __   _
/_  __/_  / /  (_) Oetiker @ ISG.EE, ETZ J97, ETH, CH-8092 Zurich
 / // _ \/ _ \/ /  System Manager, Time Lord, Coder, Designer, Coach
/_/ \.__/_.__/_/   http://people.ee.ethz.ch/~oetiker   +41(0)1-632-5286

--
Unsubscribe mailto:mrtg-request at list.ee.ethz.ch?subject=unsubscribe
Archive     http://www.ee.ethz.ch/~slist/mrtg
FAQ         http://faq.mrtg.org    Homepage     http://www.mrtg.org
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi