Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 1A8359FB251 for ; Wed, 21 Mar 2007 04:39:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 05866-07 for ; Wed, 21 Mar 2007 04:39:38 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by postgresql.org (Postfix) with ESMTP id 0D0939FA210 for ; Wed, 21 Mar 2007 04:39:49 -0300 (ADT) Received: from server3.office.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id EAA4A143C26; Wed, 21 Mar 2007 07:39:44 +0000 (GMT) Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 251FA274057; Wed, 21 Mar 2007 07:39:44 +0000 (GMT) Message-ID: <4600E13F.3070806@archonet.com> Date: Wed, 21 Mar 2007 07:39:43 +0000 From: Richard Huxton User-Agent: IceDove 1.5.0.9 (X11/20061220) MIME-Version: 1.0 To: Joe Healy Cc: Dan Harris , PostgreSQL Performance Subject: OT: Munin (was Re: Determining server load from client) References: <460080A2.20800@drivefaster.net> <46008931.8060605@omc-international.com.au> In-Reply-To: <46008931.8060605@omc-international.com.au> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/296 X-Sequence-Number: 23701 Joe Healy wrote: > (forgot to send to list) > Dan Harris wrote: >> architecture of the server hardware. It would be very nice if I could >> check the load of the server at certain intervals to throttle the >> number of concurrent queries and mitigate load problems when other >> processes might be already inducing a significant load. > I have installed munin (http://munin.projects.linpro.no/) on a few > systems. This lets you look at graphs of system resources/load etc. I > have also added python scripts which do sample queries to let me know if > performance/index size is changing dramatically. I have attached an > example script. For general monitoring of a handful of servers, I've been impressed with munin. It's very simple to get it running and write your own plugins. -- Richard Huxton Archonet Ltd