http://www.netvouz.com/henrik/tag/rrd?feed=rss henrik's bookmarks tagged "rrd" on Netvouz http://jon.netdork.net/2011/03/16/adding-a-new-datasource-to-an-rrd-database/ After upgrading several servers with a newer instance of nsclient++, we discovered Memory graphs were broken because of new performance metrics included in the check memory results. Well broken is subjective, the new performance data included the percentage free (as before), with the addition of the actual physical value (ie 1GB). This addition was missing from the RRDs when they were originally created, so when pnp4Nagios was updating the XML file it uses, it said it had 2 data sets, but the RRD only had one. Here’s how I fixed the issue. Computers > Linux henrik Sun, 19 Feb 2012 22:46:38 GMT http://blog.cymen.org/2009/06/13/mysql-and-round-robin-database-rrd/ While looking for a MySQL RRD storage engine, I came across Round-Robin Database Storage Engine (RRD) (pdf) which describes how to setup a MySQL table to act as a RRD. The PDF appears to have been created in February of 2007 but the benchmark result at the end of 600 inserts/second says this was achieved on a 1350 MHz AMD CPU which suggests the article may be older. I replicated the configuration and tested it on my laptop (5400 RPM disk, 2.4 GHz Intel T7700 CPU). With the MyISAM database, a brieft test of about 50k inserts resulted in ~7000 inserts/second. But the 25m max rows means the trigger functionality (the part that makes the table behave like an RRD) wasn’t really tested. Development henrik Mon, 11 Jul 2011 20:17:52 GMT http://www.fromdual.ch/round-robin-database-storage-engine In a round-robin database (RRD) usually time-series data like network bandwidth, temperatures, CPU load etc. is stored. The data is stored in the way that system storage footprint remains constant over time. This avoids resource expensive purge jobs and reduces complexity. RRD MySQL does NOT yet provide this kind of storage engine. Although some people were thinking about and some prototypes exists. Nevertheless in this paper it is shown how you can build your own RRD tables: Round-Robin Database Storage Engine (RRD) Development henrik Mon, 11 Jul 2011 20:19:00 GMT https://rrd4j.dev.java.net/ RRD4J is a 100% pure java implementation of RRDTool's functionality. It follows the same logic and uses the same data sources, archive types and definitions as RRDTool does. RRD4J supports all standard operations on Round Robin Database (RRD) files: CREATE, UPDATE, FETCH, LAST, DUMP, XPORT and GRAPH. RRD4J's API is made for those who are familiar with RRDTool's concepts and logic, but prefer to work with pure java. If you provide the same data to RRDTool and RRD4J, you will get exactly the same results and graphs. RRD4J is made from the scratch and it uses very limited portions of RRDTool's original source code. RRD4J does not use native functions and libraries, has no Runtime.exec() calls and does not require RRDTool to be present. Development > Java henrik Sat, 07 Apr 2007 17:39:26 GMT http://www.vandenbogaerdt.nl/rrdtool/total.php RRDtool stores rates during time intervals. Sometimes you do not want to know the rate (how many bytes per second), you just want to know the total amount of bytes. This can be done, no problem. Please make sure you understand how RRDtool normalizes and consolidates its data. This is explained on my RRDtool - Rates, normalizing and consolidating page. That page already covers most of what you need to know about this subject. You are expected to know its contents in order to understand this page. Computers > Linux henrik Mon, 14 Feb 2011 21:48:34 GMT http://www.generationip.com/docs/0003/docs-rrdtool-howto-round-robin-database-tools.html RRD is the Acronym for Round Robin Database. RRD is a system to store and display time-series data (network bandwidth, machine-room temperature, mysql queries,dns queries). This page is a good howto for using RRD, all commands listed in one single page. Computers > Linux henrik Fri, 06 Apr 2007 05:20:11 GMT http://www.temperatur.nu/forum/guider-artiklar-how-to/howto-rrdtool-pa-ubuntu-installera-logga-rita-graf-t634.html Detta är en fortsättning på HOWTO: Installera OWFS 2.7p10 på Ubuntu server 8.10 skulle man kunna säga och syftet är att kunna göra sin första graf över temperaturen. Detta är inte så knepigt, eller i alla fall inte lika knepigt som att få igång OWFS! Dock är inte RRDtool helt solklart direkt från början, det skiljer sig lite från en traditionell databas. Hus & Hem > Home Automation henrik Mon, 14 Feb 2011 06:55:03 GMT http://micah.navi.cx/2009/01/wireless-temperature-picture-frame-mashup/ This is the latest geeky addition to our home decor. It’s a Kodak W820 digital picture frame, showing a graph of real-time temperature data collected from around the house: upstairs and downstairs, garage, outdoors, and even inside the refrigerator. More photos on Flickr, implementation details below… Temperature Sensors Most of my friends probably know that back in 2004, when I was still in college, I built a set of wireless temperature sensors. Each one is an Altoids tin containing a 9V battery, a Dallas 1-wire temperature sensor, PIC microcontroller, and a little 315 MHz AM radio transmitter. I built several of these indoor wireless sensors, plus one outdoor sensor which I built out of PVC pipe. Hus & Hem > Home Automation henrik Mon, 14 Feb 2011 12:49:18 GMT