[rrd-users] rrdtool
Hi When i run rrdtool fetch memory-used.rrd AVERAGE -s 20091226 -e 20100127, i get the below values 1261822450: 2.0091517260e+09 1261848800: 2.0094235151e+09 1261875150: 2.0092428185e+09 1261901500: 2.0092623233e+09 1261927850: 2.0097005365e+09 1261954200: 2.0096478006e+09 1261980550: 2.0089728907e+09 1262006900: 2.0465407797e+09 1262033250: 2.0521587212e+09 1262059600: 2.0520784987e+09 1262085950: 2.0419800303e+09 1262112300: 2.2037169794e+09 1262138650: 2.2729663331e+09 1262165000: 2.2760922959e+09 1262191350: 2.1570277315e+09 1262217700: 1.8761143191e+09 1262244050: 1.8123204795e+09 1262270400: 1.8218329615e+09 1262296750: 1.879617e+09 I understand that the first column is time since Jan 01,1970 and the second column is the value. When i copy 1.879617e+09 in excel sheet, I get weird values, Actually it should be some readable interger value about memory usage on a particular host. Please guide. Thanks and Regards Kaushal Kaushal ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] rrdtool
On Jan 27, 2010, at 8:34 AM, Kaushal Shriyan wrote: I understand that the first column is time since Jan 01,1970 and the second column is the value. When i copy 1.879617e+09 in excel sheet, I get weird values, Actually it should be some readable interger value about memory usage on a particular host. RRD values are expressed on scientific notation (http://en.wikipedia.org/wiki/Scientific_notation). Assuming that the unit of the measurement is bytes, because you are talking about memory usage, 1.879617e+09 bytes = 1.8796 GBytes (assuming 1GB = 1,000,000,000.00 B) Alejandro. ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] rrdtool
On Jan 27, 2010, at 7:04 AM, Kaushal Shriyan wrote: I understand that the first column is time since Jan 01,1970 and the second column is the value. When i copy 1.879617e+09 in excel sheet, I get weird values, Actually it should be some readable interger value about memory usage on a particular host. It's in a standard scientific notation. 1.879617e+09 = 187961.7 =~ 1.75 GB, assuming input was in bytes. I'm not really an Excel user but I think all you need to do is make sure the cell type is 'number'. -- Marc ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] rrdtool
On Wed, Jan 27, 2010 at 6:57 PM, Marc Powell m...@ena.com wrote: On Jan 27, 2010, at 7:04 AM, Kaushal Shriyan wrote: I understand that the first column is time since Jan 01,1970 and the second column is the value. When i copy 1.879617e+09 in excel sheet, I get weird values, Actually it should be some readable interger value about memory usage on a particular host. It's in a standard scientific notation. 1.879617e+09 = 187961.7 =~ 1.75 GB, assuming input was in bytes. I'm not really an Excel user but I think all you need to do is make sure the cell type is 'number'. Hi Marc, I have 200 hosts monitored by collectd, can i import it directly in the excel sheet format, Basically I am collecting average mem usage and cpu usage for 200 servers for a period of 1 week and 1 month using rrd file. Is there a better way to do it ? Thanks and Regards, Kaushal ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] rrdtool
Hi. No you can't import RRD files into Excel ;) But you may write a shell script that generates CSV files (e.g. from rrdtool fetch) and import the generatet CSV files into Excel. HTH, Andreas. Kaushal Shriyan wrote: On Wed, Jan 27, 2010 at 6:57 PM, Marc Powell m...@ena.com wrote: On Jan 27, 2010, at 7:04 AM, Kaushal Shriyan wrote: I understand that the first column is time since Jan 01,1970 and the second column is the value. When i copy 1.879617e+09 in excel sheet, I get weird values, Actually it should be some readable interger value about memory usage on a particular host. It's in a standard scientific notation. 1.879617e+09 = 187961.7 =~ 1.75 GB, assuming input was in bytes. I'm not really an Excel user but I think all you need to do is make sure the cell type is 'number'. Hi Marc, I have 200 hosts monitored by collectd, can i import it directly in the excel sheet format, Basically I am collecting average mem usage and cpu usage for 200 servers for a period of 1 week and 1 month using rrd file. Is there a better way to do it ? Thanks and Regards, Kaushal ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users -- Dipl.-Ing. Andreas Maus science+computing ag System Administration Hagellocher Weg 73 tel.: +49 7071 9457 671 72070 Tuebingen, Germany fax: +49 7071 9457 411 www.science-computing.de -- Vorstand/Board of Management: Dr. Bernd Finkbeiner, Dr. Roland Niemeier, Dr. Arno Steitz, Dr. Ingrid Zech Vorsitzender des Aufsichtsrats/ Chairman of the Supervisory Board: Michel Lepert Sitz/Registered Office: Tuebingen Registergericht/Registration Court: Stuttgart Registernummer/Commercial Register No.: HRB 382196 ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] rrdtool
[ Comments below, in line ] On Wednesday 27 January 2010 at 8:38 am, Kaushal Shriyan penned about Re: [rrd-users] rrdtool I have 200 hosts monitored by collectd, can i import it directly in the excel sheet format, Basically I am collecting average mem usage and cpu usage for 200 servers for a period of 1 week and 1 month using rrd file. Hi, Are you importing the data into Excel so ... you can graph it? Why not use RRD to graph the data? Cheers, -- Pablo Sanchez - Blueoak Database Engineering, Inc Ph:819.459.1926 Fax: 760.860.5225 (US) ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] rrdtool
I have 200 hosts monitored by collectd, can i import it directly in the excel sheet format, Basically I am collecting average mem usage and cpu usage for 200 servers for a period of 1 week and 1 month using rrd file. Is there a better way to do it ? This is what RRDTool is made for. Why use Excel? ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] rrdtool
On Wed, Jan 27, 2010 at 7:38 PM, Fredrik W fred...@n-mental.com wrote: I have 200 hosts monitored by collectd, can i import it directly in the excel sheet format, Basically I am collecting average mem usage and cpu usage for 200 servers for a period of 1 week and 1 month using rrd file. Is there a better way to do it ? This is what RRDTool is made for. Why use Excel? Hi, can i have dates as below and not as secs since epoch time 26-01-2009 : 2.2037169794e+09 27-01-2009: 2.2729663331e+09 is that possible while running rrdtool fetch memory-used.rrd AVERAGE -s 20091226 -e 20100127 Please suggest/guide. Thanks and Regards, Kaushal ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
[rrd-users] Formating y-axis when unit is exprimed in seconds
Hello, I have a lot of graphics which use seconds as unit on y-axis : for example to graph some tasks durations etc.. My question is about y-axis formating : is there a way to reformat it to get something more readable that 32k for 32000 seconds? :) ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] rrdtool
On Wed, Jan 27, 2010 at 10:00 PM, Kaushal Shriyan kaushalshri...@gmail.com wrote: On Wed, Jan 27, 2010 at 7:38 PM, Fredrik W fred...@n-mental.com wrote: I have 200 hosts monitored by collectd, can i import it directly in the excel sheet format, Basically I am collecting average mem usage and cpu usage for 200 servers for a period of 1 week and 1 month using rrd file. Is there a better way to do it ? This is what RRDTool is made for. Why use Excel? Hi, can i have dates as below and not as secs since epoch time 26-01-2009 : 2.2037169794e+09 27-01-2009: 2.2729663331e+09 is that possible while running rrdtool fetch memory-used.rrd AVERAGE -s 20091226 -e 20100127 Please suggest/guide. Thanks and Regards, Kaushal Hi, can i have dates as below and not as secs since epoch time while running rrdtool fetch memory-used.rrd AVERAGE -s 20091226 -e 20100127 26-01-2009 : 2.2037169794e+09 27-01-2009: 2.2729663331e+09 Please suggest/guide Thanks and Regards, Kaushal ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users