Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 259F19FA339 for ; Sun, 25 Mar 2007 05:12:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 29479-05 for ; Sun, 25 Mar 2007 05:12:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from cronos.madness.at (madness.at [217.196.146.217]) by postgresql.org (Postfix) with ESMTP id D49E89F9C5A for ; Sun, 25 Mar 2007 05:12:46 -0300 (ADT) Received: from mastermind.kaltenbrunner.cc ([83.215.233.60]) by cronos.madness.at with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.63) (envelope-from ) id 1HVNpq-0007xR-Nu; Sun, 25 Mar 2007 10:12:29 +0200 Message-ID: <46062EE0.3050906@kaltenbrunner.cc> Date: Sun, 25 Mar 2007 10:12:16 +0200 From: Stefan Kaltenbrunner User-Agent: Icedove 1.5.0.9 (X11/20061220) MIME-Version: 1.0 To: CAJ CAJ CC: Erik Jones , Tobias Brox , Richard Huxton , Joe Healy , Dan Harris , PostgreSQL Performance Subject: Re: OT: Munin (was Re: Determining server load from client) References: <460080A2.20800@drivefaster.net> <46008931.8060605@omc-international.com.au> <4600E13F.3070806@archonet.com> <20070321101340.GI10137@oppetid.no> <2B568D22-BDCC-40B7-B27D-0F47216094F2@myemma.com> <20070321211305.GA29211@oppetid.no> <467669b30703242246gfac2ff5h66b5723d923520f0@mail.gmail.com> In-Reply-To: <467669b30703242246gfac2ff5h66b5723d923520f0@mail.gmail.com> X-Enigmail-Version: 0.94.2.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/392 X-Sequence-Number: 23797 CAJ CAJ wrote: > > > On 3/21/07, *Erik Jones* > wrote: > > > On Mar 21, 2007, at 4:13 PM, Tobias Brox wrote: > >> [Erik Jones - Wed at 09:31:48AM -0500] >>> I use cacti (http://cacti.net) which does the same thing that >>> munin >>> does but in php instead. Here's what I use to db stats to it >>> (again, >>> php): >> >> I haven't tried cacti, but our sysadm has done a little bit of >> research >> and concluded "cacti is better". Maybe some day we'll move over. >> >> Munin is generating all the graphs statically every fifth minute, >> while >> cacti generates them on demand as far as I've understood. The munin >> approach is pretty bloat, since one usually would watch the graphs >> much >> more seldom than what they are generated (at least, we do). >> That's not >> really an argument since CPU is cheap nowadays - but a real >> argument is >> that the munin approach is less flexible. One would like to >> adjust the >> graph (like, min/max values for both axis) while watching quite some >> times. > > Well, by "default", Cacti polls all of the data sources you've set > up every five minutes as well as that's how the docs instruct you to > set up the cron job for the poller. However, with a little > understanding of how the rrdtool rras work, you could definitely > poll more often and simply edit the existing rras and datasources to > expect that or create new ones. And, yes, the graph customization > is pretty cool although for the most part the just map what's > available from the rrdtool graph functionality. If you do decide to > set up Cacti I suggest you go straight to the faq section of the > manual and read the part about going from a simple script to a > graph. The main manual is almost entirely centered on the built-in > networking ( e.g. snmp) data sources and, as such, doesn't do much > for explaining how to set up other data sources. > > > > Has anyone had experience setting up something similar with Nagios? We > monitor servers using nagios and not having to install additional > software (cacti/munin) for postgres resource usage monitoring would be > great. a lot of nagios plugins can supply performance data in addition to the OK/WARNING/CRITICAL state information - there are a number of solutions out there that can take that information and graph it on a per hosts/server base automatically - examples for such addons are nagiosgrapher and n2rrd(or look at www.nagiosexchange.org it has a large number of addons listed). Stefan