Menu
▾
▴
perfparse-users — Problems using PerfParse
You can subscribe to this list here.
| 2004 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(12) |
Jun
(56) |
Jul
(68) |
Aug
(141) |
Sep
(82) |
Oct
(76) |
Nov
(115) |
Dec
(74) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2005 |
Jan
(65) |
Feb
(113) |
Mar
(82) |
Apr
(37) |
May
(44) |
Jun
(22) |
Jul
(12) |
Aug
(3) |
Sep
(17) |
Oct
(11) |
Nov
(23) |
Dec
(1) |
| 2006 |
Jan
(1) |
Feb
(9) |
Mar
(6) |
Apr
(12) |
May
(10) |
Jun
(23) |
Jul
(1) |
Aug
(4) |
Sep
(3) |
Oct
(4) |
Nov
(6) |
Dec
(15) |
| 2007 |
Jan
(17) |
Feb
(14) |
Mar
(20) |
Apr
(7) |
May
|
Jun
|
Jul
(1) |
Aug
|
Sep
(5) |
Oct
(1) |
Nov
|
Dec
(2) |
| 2008 |
Jan
|
Feb
|
Mar
(2) |
Apr
(2) |
May
(6) |
Jun
(5) |
Jul
(13) |
Aug
(2) |
Sep
(16) |
Oct
|
Nov
|
Dec
|
| 2010 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: lemsx1 <wk-...@pe...> - 2006-03-03 16:19:52
|
from latest cvs snapshot (2006-03-03)
First to get this to compile on Fedora Core 4, I had to change in configure.ac
AM_PROG_LIBTOOL
to
AC_PROG_LIBTOOL
Then using the following configure line, i get the following output:
./configure --prefix=/usr --with-init-dir=/etc/init.d --with-cgiurl=/na
gios/cgi-bin --with-htmurl=/nagios --with-lockfile=/var/run/nagi
os.pid --with-imagedir=/usr/share/nagios/images/ --with-cgidir=/usr/lib/nagios/
cgi --with-http_image_path=/nagios/images --sysconfdir=/etc/nagios --localstated
ir=/var
In file included from /usr/include/math.h:70,
from ../libnagios_perfdata_parser/libnagios_perfdata_parser.h:3
0,
from storage_file_output.c:39:
/usr/include/bits/mathcalls.h:202: error: syntax error before '||' token
make[2]: *** [libpp_storage_file_output_la-storage_file_output.lo] Error 1
make[2]: Leaving directory `/var/lib/gforge/chroot/home/users/user/Backup/pe
rfparse-all/modules'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/var/lib/gforge/chroot/home/users/user/Backup/pe
rfparse-all'
make: *** [all] Error 2
any help would be appreciated...
|
|
From: Flo G. <fl...@bi...> - 2006-02-25 20:42:17
|
Redefine your service check command temporary to write the data $PERFDATA (and probably $HOSTNAME) in a logfile. Check if the performance data on your hpux box look strange. Flo On Thu, 23 Feb 2006, Steiner, Roberth wrote: > I'll try to explain this so it makes sense. ;) > > > > I got the perfparsed pipe method installed and working, kind of anyways. > > > > It generates graphs of some of my service checks but not all of them, at > first I thought that this is the way it should work, not all of the > gathered data can be viewed as graphs as default. > > > > But then I got a little bit confused as one of the "check_disk" checks > is displayed with graphs but not the other one. > > Both are collected using the "nrpe" agent but only one of them is > displayed. > > > > Here is the setup: > > > > SERVER1: > > - hpux 11.11 > > - Plugin: check_disk - "No Graph" > > - Plugin: check_icmp - "GRAPH" > > - NRPE > > > > SERVER2: > > - RH Ent 3.0 AS > > - Plugin: check_disk - "GRAPH" > > - Plugin: check_icmp - "GRAPH" > > - NRPE > > > > When I check the binary data graphs I only see graphs from server2 and > not from server1. > > > > I'm kind of stuck and hoping that someone out there have had the same > problem and can guide me into the right direction. > > > > Best regz, > > /Robban > > > > ------------------------------------------------------------------------ > ----------- > Roberth Steiner > SJMVE CRMD IT-ISD - DBA, *NIX SysAdmin > ------------------------------------------------------------------------ > ----------- > > > > |
|
From: Steiner, R. <RSt...@sj...> - 2006-02-23 14:28:54
|
I'll try to explain this so it makes sense. ;) =20 I got the perfparsed pipe method installed and working, kind of anyways. =20 It generates graphs of some of my service checks but not all of them, at first I thought that this is the way it should work, not all of the gathered data can be viewed as graphs as default. =20 But then I got a little bit confused as one of the "check_disk" checks is displayed with graphs but not the other one. Both are collected using the "nrpe" agent but only one of them is displayed. =20 Here is the setup: =20 SERVER1:=20 - hpux 11.11 - Plugin: check_disk - "No Graph" - Plugin: check_icmp - "GRAPH" - NRPE =20 SERVER2: - RH Ent 3.0 AS - Plugin: check_disk - "GRAPH" - Plugin: check_icmp - "GRAPH" - NRPE =20 When I check the binary data graphs I only see graphs from server2 and not from server1. =20 I'm kind of stuck and hoping that someone out there have had the same problem and can guide me into the right direction. =20 Best regz, /Robban =20 ------------------------------------------------------------------------ ----------- Roberth Steiner SJMVE CRMD IT-ISD - DBA, *NIX SysAdmin ------------------------------------------------------------------------ ----------- =20 |
|
From: <wk-...@pe...> - 2006-02-09 12:23:51
|
Re: Compile Errors Dear people, I give of. Or so. I don't recieved answers and I have the problem in otherwise put on. bye You can Delete this .. |
|
From: Yves <yme...@pe...> - 2006-02-06 13:49:50
|
(sorry for double posting : I forgot to CC the mailing-list :) Hello, > Re: compile error > Hallo, > ich habe auch ein Problem beim kompilien. If you don't mind, please use English here to have more chance to get hel= p. (I understand only "Problem" and "kompilien" :) > libtool: install: error: cannot install `libpp_storage_mysql.la' to a d= irectory not ending in /usr/local/nagios/lib What did you type ? What OS are you compiling on ? Do you have more infos that you can tell us to help to understand the pro= blem ? Yves --=20 - Homepage - http://ymettier.free.fr - http://www.logicacmg.com - - GPG key - http://ymettier.free.fr/gpg.txt - - Maitretarot - http://www.nongnu.org/maitretarot/ - - Perfparse - http://www.perfparse.org/ - |
|
From: <wk-...@pe...> - 2006-02-06 11:52:20
|
Re: compile error Hallo, ich habe auch ein Problem beim kompilien. libtool: install: error: cannot install `libpp_storage_mysql.la' to a directory not ending in /usr/local/nagios/lib |
|
From: <mi...@se...> - 2006-02-03 00:57:37
|
Sorry about not replying to the list. Thanks for the response, it must've been my service template. I created a clean one and it all worked fine. Thanks again, Mike On 12/31/1969, "Daniele Coli`" <dan...@ti...> wrote: >Yes, I get the same output. Make sure you delete the pipe char from >illegal macro output options, defined in nagios.cfg file; this is mine: > ># ILLEGAL MACRO OUTPUT CHARACTERS >#illegal_macro_output_chars=3D`~$&|'"<> >illegal_macro_output_chars=3D`~$&"<> > > >Bye. > >Daniele Coli` > >P.S. >Please, reply in list so everybody can read/write suggestions... > > >mi...@se... ha scritto: >> Thanks for the response. Maybe it is me then. Does this look like the ou= tput you get? >> >> ./check_icmp -H <myhost> >> OK - <myhost>: rta 83.2 ms, lost 0%|rta=3D83.2ms;200;500;; pl=3D0%;60;80;; >> >> -------------- Original message ---------------------- >> From: Daniele Coli` <dan...@ti...> >> >>> Hi, >>> I use check_icmp version 0.8.1 and it works well (I compiled it from >>> nagios-plugins-1.4.0.a3). >>> >>> >>> Daniele >>> >>> mi...@se... wrote: >>> >>>> Anyone have a working check_ping or check_icmp? I've tried all the ones= I can >>>> find and googled like crazy. I'm new to perfparse and I'm not a c coder= and >>>> >>> it >>> >>>> sure looks like the latest check_icmp outputs the data in the wrong form= at >>>> (keeps going into drop bin). If anyone could send me the source for a w= orking >>>> ping check it would be very appreciated... >>>> >>>> Mike >>>> >>>> >>>> ------------------------------------------------------- >>>> This SF.net email is sponsored by: Splunk Inc. Do you grep through log f= iles >>>> for problems? Stop! Download the new AJAX search engine that makes >>>> searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! >>>> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D103432&bid=3D230486&dat= =3D121642 >>>> _______________________________________________ >>>> Perfparse-users mailing list >>>> Per...@li... >>>> https://lists.sourceforge.net/lists/listinfo/perfparse-users >>>> >>>> >>>> >>> >>> >>> ------------------------------------------------------- >>> This SF.net email is sponsored by: Splunk Inc. Do you grep through log fi= les >>> for problems? Stop! Download the new AJAX search engine that makes >>> searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! >>> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D103432&bid=3D230486&dat= =3D121642 >>> _______________________________________________ >>> Perfparse-users mailing list >>> Per...@li... >>> https://lists.sourceforge.net/lists/listinfo/perfparse-users >>> >>> >>> >> >> >> >> > > > > >------------------------------------------------------- >This SF.net email is sponsored by: Splunk Inc. Do you grep through log files >for problems? Stop! Download the new AJAX search engine that makes >searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! >http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D103432&bid=3D230486&dat=3D12= 1642 >_______________________________________________ >Perfparse-users mailing list >Per...@li... >https://lists.sourceforge.net/lists/listinfo/perfparse-users > > > |
|
From: Daniele C. <dan...@ti...> - 2006-02-02 10:31:04
|
Yes, I get the same output. Make sure you delete the pipe char from illegal macro output options, defined in nagios.cfg file; this is mine: # ILLEGAL MACRO OUTPUT CHARACTERS #illegal_macro_output_chars=`~$&|'"<> illegal_macro_output_chars=`~$&"<> Bye. Daniele Coli` P.S. Please, reply in list so everybody can read/write suggestions... mi...@se... ha scritto: > Thanks for the response. Maybe it is me then. Does this look like the output you get? > > ./check_icmp -H <myhost> > OK - <myhost>: rta 83.2 ms, lost 0%|rta=83.2ms;200;500;; pl=0%;60;80;; > > -------------- Original message ---------------------- > From: Daniele Coli` <dan...@ti...> > >> Hi, >> I use check_icmp version 0.8.1 and it works well (I compiled it from >> nagios-plugins-1.4.0.a3). >> >> >> Daniele >> >> mi...@se... wrote: >> >>> Anyone have a working check_ping or check_icmp? I've tried all the ones I can >>> find and googled like crazy. I'm new to perfparse and I'm not a c coder and >>> >> it >> >>> sure looks like the latest check_icmp outputs the data in the wrong format >>> (keeps going into drop bin). If anyone could send me the source for a working >>> ping check it would be very appreciated... >>> >>> Mike >>> >>> >>> ------------------------------------------------------- >>> This SF.net email is sponsored by: Splunk Inc. Do you grep through log files >>> for problems? Stop! Download the new AJAX search engine that makes >>> searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! >>> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 >>> _______________________________________________ >>> Perfparse-users mailing list >>> Per...@li... >>> https://lists.sourceforge.net/lists/listinfo/perfparse-users >>> >>> >>> >> >> >> ------------------------------------------------------- >> This SF.net email is sponsored by: Splunk Inc. Do you grep through log files >> for problems? Stop! Download the new AJAX search engine that makes >> searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! >> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 >> _______________________________________________ >> Perfparse-users mailing list >> Per...@li... >> https://lists.sourceforge.net/lists/listinfo/perfparse-users >> >> >> > > > > |
|
From: Daniele C. <dan...@ti...> - 2006-02-01 15:59:17
|
Hi, I use check_icmp version 0.8.1 and it works well (I compiled it from nagios-plugins-1.4.0.a3). Daniele mi...@se... wrote: > Anyone have a working check_ping or check_icmp? I've tried all the ones I can > find and googled like crazy. I'm new to perfparse and I'm not a c coder and it > sure looks like the latest check_icmp outputs the data in the wrong format > (keeps going into drop bin). If anyone could send me the source for a working > ping check it would be very appreciated... > > Mike > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 > _______________________________________________ > Perfparse-users mailing list > Per...@li... > https://lists.sourceforge.net/lists/listinfo/perfparse-users > > |
|
From: <mi...@se...> - 2006-02-01 15:47:51
|
Anyone have a working check_ping or check_icmp? I've tried all the ones I can find and googled like crazy. I'm new to perfparse and I'm not a c coder and it sure looks like the latest check_icmp outputs the data in the wrong format (keeps going into drop bin). If anyone could send me the source for a working ping check it would be very appreciated... Mike |
|
From: <wk-...@pe...> - 2006-01-04 13:16:47
|
Aw: Aw: RAW data but no graph Answer to myself: From a mail from Ben: Can you check your nagios.cfg and look for this line: illegal_macro_output_chars=`~$&|'" If it exists, please change to: illegal_macro_output_chars=`~$&|" (You plugin is correct to the specification, but Nagios is not correct to it's own specification :) Ben |
|
From: barry.maclean <bar...@sh...> - 2005-12-19 03:48:07
|
Sorry but I'm confused?
In the docs at 5.4 when it states
Edit a script like this :
#!/bin/sh
$USER2=/perfparse/installation/directory
mv ${USER2}/var/perfdata-service.log ${USER2}/var/perfdata-service.log1
cat ${USER2}
What script do I edit??
Is there a dummy's guide to using Periodic User Log Parse??
Thanks Barry
|
|
From: <GR...@PR...> - 2005-11-22 14:06:25
|
Hi all, I have got a problem with the cgi:=20 The database is filling and the cgi displays=20 graphs of check_icmp very nicely, but if I=20 choose a custom Period or Scale, after clicking=20 the "Draw Graph"-Button the image is blank=20 without any header or graph. As I am just starting with perfparse, I am pretty sure that the problem is in my config, but I am=20 stuck now.=20 Any hint would be appreciated. By the way, is it possible to configure a loglevel? Gruss, G=F6tz |
|
From: Yves <yme...@pe...> - 2005-11-14 16:49:51
|
> On 11/14/05, Yves <yme...@pe...> wrote: >> This bug has already been fixed in the parser. > > How? It uses the extended data from the plugins : warning and critical zones i= nstead of limits between zones. Except if you are a developer and want to help on the database storage, t= his should not be very helpful. Ask me for more info on per...@li... if you can = do something for perfparse ! :) Yves --=20 - Homepage - http://ymettier.free.fr - http://www.logicacmg.com - - GPG key - http://ymettier.free.fr/gpg.txt - - Maitretarot - http://www.nongnu.org/maitretarot/ - - Perfparse - http://www.perfparse.org/ - |
|
From: J P. <pa...@gm...> - 2005-11-14 15:19:52
|
On 11/14/05, Yves <yme...@pe...> wrote: > This bug has already been fixed in the parser. How? |
|
From: Yves <yme...@pe...> - 2005-11-14 11:35:39
|
Hi Christophe, This is a bug in the conception of Perfparse : it considers that low valu= es are OK and high values are critical. This bug has already been fixed in the parser. We need to fix it in the GUI too. If you need a fix soon, the best is probably to reverse the plugin value = and have "% used" instead of "% free". Yves > Hello, > config: Nagios 2.0b4 and perfparse 0.105.6. > I have a problem with the value reported by check_swap, in nagios the = value > is OK and it is reported as critical in perfparse. > I have this problem only with chek_swap plugin. > SWAP OK: 100% free (2102 MB out of 2102 MB) |swap=3D2101MB;420;210;0;2= 101 > 1131966271 lblnagios1 Swap SWAP OK: 100% free (2102 MB out of 2102 MB) = OK > swap=3D2101MB;420;210;0;2101 > Perfparse result --> Swap swap 2005-11-14 11:59:31 2101 MB CRITIC= AL > > -- > Christophe > --=20 - Homepage - http://ymettier.free.fr - http://www.logicacmg.com - - GPG key - http://ymettier.free.fr/gpg.txt - - Maitretarot - http://www.nongnu.org/maitretarot/ - - Perfparse - http://www.perfparse.org/ - |
|
From: Christophe <cgo...@gm...> - 2005-11-14 11:18:10
|
Hello, config: Nagios 2.0b4 and perfparse 0.105.6. I have a problem with the value reported by check_swap, in nagios the valu= e is OK and it is reported as critical in perfparse. I have this problem only with chek_swap plugin. SWAP OK: 100% free (2102 MB out of 2102 MB) |swap=3D2101MB;420;210;0;2101 1131966271 lblnagios1 Swap SWAP OK: 100% free (2102 MB out of 2102 MB) OK swap=3D2101MB;420;210;0;2101 Perfparse result --> Swap swap 2005-11-14 11:59:31 2101 MB CRITICAL -- Christophe |
|
From: Ben C. <bcl...@pe...> - 2005-11-09 16:56:28
|
Can you check your nagios.cfg and look for this line: illegal_macro_output_chars=`~$&|'"<> If it exists, please change to: illegal_macro_output_chars=`~$&|"<> (You plugin is correct to the specification, but Nagios is not correct to it's own specification :) Ben Christophe wrote: > Hello, > > I use nagios 2.0b4 and pp 0.105.6. > Values comming from check_nt plugin are not recorded in the pp db. > Other vlues (ie ping, linux, ..) are correct. > > This values are right in the plugin result. > ./check_nt -H XXXXXX -v CPULOAD -p 1248 -l 1,80,90,5,80,90,15,80,90 > CPU Load 8% (1 min average) 7% (5 min average) 15% (15 min average) | > '1 min avg Load'=8%;80;90;0;100 '5 min avg Load'=7%;80;90;0;100 '15 min > avg Load'=15%;80;90;0;100 > > Has anybody seen thet ? > > Thank you. > > -- > Christophe |
|
From: Christophe <cgo...@gm...> - 2005-11-09 16:43:52
|
Hello, I use nagios 2.0b4 and pp 0.105.6. Values comming from check_nt plugin are not recorded in the pp db. Other vlues (ie ping, linux, ..) are correct. This values are right in the plugin result. ./check_nt -H XXXXXX -v CPULOAD -p 1248 -l 1,80,90,5,80,90,15,80,90 CPU Load 8% (1 min average) 7% (5 min average) 15% (15 min average) | '1 mi= n avg Load'=3D8%;80;90;0;100 '5 min avg Load'=3D7%;80;90;0;100 '15 min avg Load'=3D15%;80;90;0;100 Has anybody seen thet ? Thank you. -- Christophe |
|
From: J P. <pa...@gm...> - 2005-11-08 10:33:55
|
On 11/8/05, Ben Clewett <bcl...@pe...> wrote: > > The specification states that 'warning' and 'critical' are always above > the line. There is a more advanced option which allows the user to > specify a range. But this is not fully supported in PP at the moment. > It is planned. > > Ben > I'm not sure I understand. For say, load average, something above 5 is a warning. For say, temperature, something below 5 might be a warning. Does this mean that all perfparse will always regard values above the warning value as bad, even though for some plugins this will be wrong? |
|
From: Ben C. <bcl...@pe...> - 2005-11-08 08:22:40
|
The specification states that 'warning' and 'critical' are always above the line. There is a more advanced option which allows the user to specify a range. But this is not fully supported in PP at the moment. It is planned. Ben J Paston wrote: > On 11/7/05, *J Paston* <pa...@gm... <mailto:pa...@gm...>> wrote: > > Hello. > It seems that quite a few nagios plugins written in C set a type for > the performance data, and return that. So if the plugin fails, the > plugin might return 0.00 for a piece of performance data. > > How can perfparse handle this? > I mean without perfparse assuming the value is correct, and drawing > a critical area on the chart? > > Thanks > > > Actually, come to think of it, how does perfparse know what a value > above or below a given critical value is "good" or "bad"? |
|
From: J P. <pa...@gm...> - 2005-11-07 14:34:16
|
On 11/7/05, J Paston <pa...@gm...> wrote: > > Hello. > It seems that quite a few nagios plugins written in C set a type for the > performance data, and return that. So if the plugin fails, the plugin mig= ht > return 0.00 for a piece of performance data. > > How can perfparse handle this? > I mean without perfparse assuming the value is correct, and drawing a > critical area on the chart? > > Thanks > Actually, come to think of it, how does perfparse know what a value above o= r below a given critical value is "good" or "bad"? |
|
From: J P. <pa...@gm...> - 2005-11-07 14:14:20
|
Hello. It seems that quite a few nagios plugins written in C set a type for the performance data, and return that. So if the plugin fails, the plugin might return 0.00 for a piece of performance data. How can perfparse handle this? I mean without perfparse assuming the value is correct, and drawing a critical area on the chart? Thanks |
|
From: Jordan K. <Jor...@ro...> - 2005-11-02 14:59:21
|
Hi, Yes, I'm in the sunny old UK! The other guy (Jon) was having the problem with 8 hours, my graph's dates are a day out of sync somehow! If I select a range of dates (eg: 2005-10-25 00:00:01 -> 2005-11-02 23:59:59), it shows the dates on the graph from 25/10 to 01/11, but the partial data (ie: today's data), is shown on the 01/11 rather than 02/11. See: http://64.69.162.90/nagios/cgi-bin/perfgant.png?host=3Dwebsites&service=3D= ht tp%3A%2F%2Fwww%2Erutland%2Egov%2Euk%2F&from=3D2005%2F10%2F25+00%3A00%3A01= & to=3D2005%2F11%2F02+23%3A59%3A59 That graph should have data 2005-10-25 00:00:01 -> 2005-11-02 23:59:59, but the data that should be shown for today, is shown as yesterdays. The data is updated every 10mins so you can even see the graph for what should be today's data expanding. Hopefully that makes sense! If not, let me know and I'll have another go at explaining it! Jordan -----Original Message----- From: Ben Clewett [mailto:bcl...@pe...]=20 Sent: 02 November 2005 14:34 To: Jordan Kirby Cc: Ben Clewett; per...@li... Subject: Re: [Perfparse-users] Graph dates wrong Jordon, You say your Nagios and MySQL server are set to GMT. From last week this should be correct. (I guess you co.uk means you are in the UK.) Can you give me more information. When you select an absolute time range, is the data you get back in the correct range, but the data relating to 8 hours ago. Or is the data 8 hours out from your date range, but otherwise correct? Ben Jordan Kirby wrote: > Hi, >=20 > Yeah, the times are correct in the database. >=20 > mysql> select ctime from perfdata_service_bin order by id desc limit=20 > mysql> 10; > +---------------------+ > | ctime | > +---------------------+ > | 2005-11-02 14:16:56 | > | 2005-11-02 14:16:55 | > | 2005-11-02 14:15:56 | > | 2005-11-02 14:15:56 | > | 2005-11-02 14:15:56 | > | 2005-11-02 14:15:45 | > | 2005-11-02 14:15:15 | > | 2005-11-02 14:15:15 | > | 2005-11-02 14:15:15 | > | 2005-11-02 14:15:15 | > +---------------------+ > 10 rows in set (0.00 sec) >=20 > Both the nagios server and the mysql server machines are set to GMT too. >=20 > Jordan > =20 >=20 > -----Original Message----- > From: Ben Clewett [mailto:bcl...@pe...] > Sent: 02 November 2005 14:14 > To: Jordan Kirby > Cc: per...@li... > Subject: Re: [Perfparse-users] Graph dates wrong >=20 > Jordan, >=20 > MySQL 4.0 is dumb on time zone information, so this is probably not=20 > the cause of the problems. >=20 > This can be checked, look at the time of the last entries: >=20 > mysql> select ctime from perfdata_service_bin order by id desc limit=20 > mysql> 10; >=20 > Are these times correct? >=20 > PerfParse also uses your operating system date functions. Please=20 > ensure that your operating system is set to your correct time zone. =20 > This may be the problem. >=20 > Regards, >=20 > Ben >=20 >=20 > Jordan Kirby wrote: >=20 >>Just realised I didn't do a reply to all, so the list didn't get >=20 > it..... >=20 >> >>-----Original Message----- >>From: Jordan Kirby >>Sent: 02 November 2005 13:24 >>To: 'Ben Clewett' >>Subject: RE: [Perfparse-users] Graph dates wrong >> >>Hi, >> >>We're running mysql 4.0.23.=20 >>It looks like the timezone info is held in the variable "timezone" >>(according to "show variables" anyway). I just can't change it, from=20 >>what I can see it's a config file change required (it's a production=20 >>mysql server so can't really do anything that'd require a restart). >>Seeing as show variables reports GMT, and that's what I need it to be, >=20 >=20 >>doesn't that indicate it's correct? >> >>Thanks >> >>Jordan >> >>-----Original Message----- >>From: Ben Clewett [mailto:bcl...@pe...] >>Sent: 02 November 2005 12:51 >>To: Jordan Kirby >>Cc: per...@li... >>Subject: Re: [Perfparse-users] Graph dates wrong >> >>I think this may be past of the problem. MySQL seems confused as to=20 >>what time zone it is in. >> >>Can you tell me what version you are using? >> >>With version 4.0 when upgraded to 4.1 (or greater), the timezone=20 >>information is not included. There is a program (somewhere) to=20 >>generate the timezone tables and content. I am sure there is a good=20 >>page somewhere on: >> >>http://dev.mysql.com/doc/refman/5.0/en/index.html >> >>Regards, >> >>Ben >> >> >>Jordan Kirby wrote: >> >> >>>Hi, >>> >>>The timezone is correctly set to GMT, and SELECT now(); returns the=20 >>>correct date/time. >>>I can't seem to set the timezone in mysql to anything different (if I >>>try "SET timezone =3D 'posix/UTC'; " I just get unknown system=20 >>>variable, >> >> >>>the same with time_zone). >>> >>>SHOW VARIABLES; reports the timezone as GMT. >>> >>> >>> >>>Jordan >>> >>> >>> >>>-----Original Message----- >>>From: per...@li... >>>[mailto:per...@li...] On Behalf Of Ben >>>Clewett >>>Sent: 02 November 2005 08:27 >>>To: Jonnathan Colt >>>Cc: per...@li... >>>Subject: Re: [Perfparse-users] Graph dates wrong >>> >>>Can you please check the time zone on your system is correct? I=20 >>>believe some of the figures are stored as UTC and converted to your >> >>time zone on >> >> >>> read. Both on your MySQL system and the Perfparse / Nagios system. >>> >>>If not this may be a bug. >>> >>>Check your UNIX installation on configuration to set your UNIX >> >>timezone. >> >> >>>You can check this easily in MySQL: >>> >>>mysql> SELECT NOW(); >>>mysql> SET SET time_zone =3D 'posix/UTC'; SELECT NOW(); SET SET=20 >>>mysql> time_zone =3D 'America/Los_Angeles'; SELECT NOW(); >>> >>>Do these return correct values? >>> >>>Regards, >>> >>>Ben Clewett. >>> >>>Jonnathan Colt wrote: >>> >>> >>> >>>>I have the same problem with graphs not showing the correct time,=20 >>>>mine >>> >>> >>>>are about 8 hours off. The server is correct in my case as well..... >>>> >>>>Thanks, >>>>Jon >>>> >>>>Jordan Kirby wrote: >>>> >>>> >>>> >>>> >>>>>Hi, >>>>> >>>>>I'm seeing a slightly odd problem with the rendered graphs. >>>>>See: >>>>>http://64.69.162.90/nagios/cgi-bin/perfgant.png?host=3Dwebsites&serv= i >>>>>c >>>>>e >>>>>=3Dht >>>>>tp%3A%2F%2Fwww%2Erutland%2Egov%2Euk%2F&from=3D2005%2F10%2F01+00%3A00= % >>>>>3 >>>>>A >>>>>01& >>>>>to=3D2005%2F11%2F1+23%3A59%3A59 >>>>> >>>>>That _should_ be showing from "2005-10-01 00:00:01" to "2005-11-01=20 >>>>>23:59:59", yet when the graph is drawn it's showing today's data >=20 > (ie. >=20 >>>>>The incomplete data) on yesterdays date, and also an hour ahead.=20 >>>>>The >=20 >=20 >>>>>server date and time are correctly set, and so is the hardware=20 >>>>>clock >=20 >=20 >>>>>on the server. The data in the database contains the correct date=20 >>>>>and >>> >>> >>>>>time too. >>>>> >>>>>Anyone got any ideas why it's doing this? >>>>> >>>>>Thanks >>>>> >>>>>Jordan >>>>> >>>>> >>>>>------------------------------------------------------- >>>>>This SF.Net email is sponsored by the JBoss Inc. >>>>>Get Certified Today * Register for a JBoss Training Course Free=20 >>>>>Certification Exam for All Training Attendees Through End of 2005=20 >>>>>Visit http://www.jboss.com/services/certification for more=20 >>>>>information _______________________________________________ >>>>>Perfparse-users mailing list >>>>>Per...@li... >>>>>https://lists.sourceforge.net/lists/listinfo/perfparse-users >>>>> >>>>> >>>> >>>> >>>> >>>>------------------------------------------------------- >>>>SF.Net email is sponsored by: >>>>Tame your development challenges with Apache's Geronimo App Server.=20 >>>>Download >>>>it for free - -and be entered to win a 42" plasma tv or your very=20 >>>>own >=20 >=20 >>>>Sony(tm)PSP. Click here to play:=20 >>>>http://sourceforge.net/geronimo.php >>>>_______________________________________________ >>>>Perfparse-users mailing list >>>>Per...@li... >>>>https://lists.sourceforge.net/lists/listinfo/perfparse-users >>>> >>> >>> >>> >>> >>>------------------------------------------------------- >>>SF.Net email is sponsored by: >>>Tame your development challenges with Apache's Geronimo App Server. >>>Download it for free - -and be entered to win a 42" plasma tv or your >>>very own Sony(tm)PSP. Click here to play: >>>http://sourceforge.net/geronimo.php >>>_______________________________________________ >>>Perfparse-users mailing list >>>Per...@li... >>>https://lists.sourceforge.net/lists/listinfo/perfparse-users >>> >>> >>>------------------------------------------------------- >>>SF.Net email is sponsored by: >>>Tame your development challenges with Apache's Geronimo App Server.=20 >>>Download it for free - -and be entered to win a 42" plasma tv or your >>>very own Sony(tm)PSP. Click here to play: >>>http://sourceforge.net/geronimo.php >>>_______________________________________________ >>>Perfparse-users mailing list >>>Per...@li... >>>https://lists.sourceforge.net/lists/listinfo/perfparse-users >>> >> >> >> >> >>------------------------------------------------------- >>SF.Net email is sponsored by: >>Tame your development challenges with Apache's Geronimo App Server.=20 >>Download it for free - -and be entered to win a 42" plasma tv or your=20 >>very own Sony(tm)PSP. Click here to play: >>http://sourceforge.net/geronimo.php >>_______________________________________________ >>Perfparse-users mailing list >>Per...@li... >>https://lists.sourceforge.net/lists/listinfo/perfparse-users >> >=20 >=20 >=20 >=20 > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server.=20 > Download it for free - -and be entered to win a 42" plasma tv or your=20 > very own Sony(tm)PSP. Click here to play:=20 > http://sourceforge.net/geronimo.php > _______________________________________________ > Perfparse-users mailing list > Per...@li... > https://lists.sourceforge.net/lists/listinfo/perfparse-users >=20 |
|
From: Ben C. <bcl...@pe...> - 2005-11-02 14:50:08
|
Sorry about that, MySQL is a bit slow on the deletion. If you run the deletion over night every night, then a days data deletes a bit better. You may want to trim it by a few days at a time over night and see how that goes... Ben barry maclean wrote: > I have been gathering stats over 700+ servers for 3-4 months and the database has grown to 75GB. I'm looking to tidy up the database and only have 1 month on-line. I know this should have been done at the start. > > When I try and run a script to delete entries before a date it does delete but very very slow. Any help on tuning the database would be great. > > Many Thanks Barry > > > > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server. Download > it for free - -and be entered to win a 42" plasma tv or your very own > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > _______________________________________________ > Perfparse-users mailing list > Per...@li... > https://lists.sourceforge.net/lists/listinfo/perfparse-users > |
34 messages has been excluded from this view by a project administrator.
