10-07-2009
moving rrd data to mysql
All
I currently run an application called OpenNMS. This is a free enterprise grade NMS. Its current framework uses RRDs to collect performance/node level data such as cpu load via snmp. all data is stored in these RRDs. I was wondering if anyone out there has had a chance or a need to move the data in the RRDs to MySQL or some other relational database such as postgresql, etc.
thoughts on this one ?
8 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Dear All,
I have 2 databases, There is a lot of data in both the databases, i would like to move some data from one database to the other. I would like to accept 2 parameters from the user, i.e. emplyee id & dept, on entering the 2 i will unload all the data from the tables to the flat files.... (2 Replies)
Discussion started by: lloydnwo
2 Replies
2. Shell Programming and Scripting
Dear All,
I have 2 databases, There is a lot of data in both the databases, i would like to move some data from one database to the other. I would like to accept 2 parameters from the user, i.e. emplyee id & dept, on entering the 2 i will unload all the data from the tables to the flat files.... (6 Replies)
Discussion started by: lloydnwo
6 Replies
3. Shell Programming and Scripting
Here we have concern. We have a IBM software installed in a server S1 in the location : /opt/IBM.
In this server S1, we have /opt file system in local disk. We don't have any option to increase the file system there.
We have created a separate /opt/IBM_NEW file system with 10GB in S1 server.... (1 Reply)
Discussion started by: mehimadri
1 Replies
4. Shell Programming and Scripting
Hi,
I have a data file that lists a number of files. I want to move the files named in that one to another directory. Here's what I have:
#!/usr/bin/perl -w
open(FILE, "<collision.txt");
my @lines=<FILE>;
foreach my $lines (@lines) {
system("mv $lines collisions/.");
}
close(FILE);
... (2 Replies)
Discussion started by: renthead720
2 Replies
5. Shell Programming and Scripting
Hi,
I am trying to move a column from one position to another position in a delimited file. The positions are dynamic in nature and are available by environmental variables. Also the file can have n number of columns.
Example:
Initial Column Position=1
Final Column Position=3
Delimiter='|'
... (2 Replies)
Discussion started by: ayan153
2 Replies
6. UNIX for Dummies Questions & Answers
Suppose there is a file Text1.txt which contains 100 lines. I need to move 1st 25 line into another file Text2.txt How we can do it?
Suppose there is a file Text1.txt in which city: Bangalore is repeating N times. I need to replace Bangalore with Delhi. How we can do... (1 Reply)
Discussion started by: Rajesh1412
1 Replies
7. Shell Programming and Scripting
I'm scanning a list of emails- I need to pull 2 pieces of data, then move to the next file:
Sender's Email Address
Email Date
I need these to be outputted into a single column- separated by a ",". Like this:
Email1's Address, Email1's Date Stamp
Email2's Address, Email2's Date Stamp... (4 Replies)
Discussion started by: sudo
4 Replies
8. UNIX for Beginners Questions & Answers
Hi Team,
Can you help me with writing shell script to printing the list output to 2nd column in HTML file. (2 Replies)
Discussion started by: veereshshenoy
2 Replies
LEARN ABOUT DEBIAN
rrdcollect.conf
RRDCOLLECT.CONF(5) RRDcollect RRDCOLLECT.CONF(5)
NAME
rrdcollect.conf -- RRDcollect configuration file.
SYNOPSIS
/etc/rrdcollect.conf
DESCRIPTION
The rrdcollect.conf file contains information where to look for data and to which database file put it.
Variables
# Configuration values:
step = 60
directory = /var/local/rrd
loglevel = LOG_NOTICE
Patterns
# System statistics:
file:///proc/stat
"cpu %d %d %d %d" stat.rrd:user,nice,system,idle
"processes %u" stat.rrd:processes
"swap %u %u" stat.rrd:swap_in,swap_out
# System load: 1, 5 and 15 min. average
file:///proc/loadavg
"%f %f %f" avg1.rrd:load,avg5.rrd:load,avg15.rrd:load
# Memory usage:
file:///proc/meminfo
"Mem: %*d %d %d %d %d %d" memory.rrd:used,free,shared,buffers,cached
"Swap: %*d %d %*d" memory.rrd:swap_used
# S.M.A.R.T. HDD temperature:
file:///proc/ide/hda/smart_values
7:"%*04x %*04x %02x%*02x" temperature.rrd:hda
Regular expressions
# Using regular expressions:
file:///proc/stat
/cpu (d+) (d+) (d+) (d+)/ stat.rrd:user,nice,system,idle
Please look into examples/ directory for working examples.
FILES
/etc/rrdcollect.conf
SEE ALSO
rrdcollect(8), rrdtool(1), pcre(3)
AUTHOR
Dawid Kuroczko <qnex@knm.org.pl>
Artur R. Czechowski <arturcz@hell.pl>
2 September 2002 RRDcollect 0.2.10 RRDCOLLECT.CONF(5)