[rrd-users] Gathering number of entries being loaded into SQL DB per hour.

[William R. Lorenz]

Hi Micha,

On Mon, 24 Nov 2008, Michal Drozdziewicz wrote:

> I have a problem designing rrd database. The case is I want to keep 
> track of number of entries being loaded into the database. My approach 
> is to query for number of inventories that were loaded from one hour 
> before till NOW and then store this number. But I have a problem with 
> designing DS and RRA's. Any help would be greatly appreciated.

Why not simply have the DS/RRA expect an entry every hour, and then do a 
'SELECT COUNT(*) FROM table' with the appropriate WHERE clause and then 
call-out to rrdtool as you run the query each hour?  This should be no 
different than using rrdtool to track other variables each hour with the 
appropriate RRA archive times to meet your data retention requirements.

Is there a specific problem you have when trying to implement this?

--
William R. Lorenz