Re: OT: Munin (was Re: [PERFORM] Determining server load from client)

2007-03-25 Thread Stefan Kaltenbrunner
CAJ CAJ wrote: > > > On 3/21/07, *Erik Jones* <[EMAIL PROTECTED] > 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 >>

Re: OT: Munin (was Re: [PERFORM] Determining server load from client)

2007-03-24 Thread CAJ CAJ
On 3/21/07, Erik Jones <[EMAIL PROTECTED]> 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

Re: OT: Munin (was Re: [PERFORM] Determining server load from client)

2007-03-21 Thread Erik Jones
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 o

Re: OT: Munin (was Re: [PERFORM] Determining server load from client)

2007-03-21 Thread Tobias Brox
[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".

Re: OT: Munin (was Re: [PERFORM] Determining server load from client)

2007-03-21 Thread Erik Jones
On Mar 21, 2007, at 5:13 AM, Tobias Brox wrote: I have my postgres munin monitoring script at http://oppetid.no/~tobixen/pg_activity.munin.txt (had to suffix it with .txt to make the local apache happy). I would like to see what others have done as well. I use cacti (http://cacti.net) whi

Re: OT: Munin (was Re: [PERFORM] Determining server load from client)

2007-03-21 Thread Richard Huxton
Tobias Brox wrote: I have my postgres munin monitoring script at http://oppetid.no/~tobixen/pg_activity.munin.txt (had to suffix it with .txt to make the local apache happy). I would like to see what others have done as well. Well, I use Perl rather than shell, but that's just me. The main di

Re: OT: Munin (was Re: [PERFORM] Determining server load from client)

2007-03-21 Thread Tobias Brox
I have my postgres munin monitoring script at http://oppetid.no/~tobixen/pg_activity.munin.txt (had to suffix it with .txt to make the local apache happy). I would like to see what others have done as well. ---(end of broadcast)--- TIP 1: if postin

OT: Munin (was Re: [PERFORM] Determining server load from client)

2007-03-20 Thread Richard Huxton
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 ind

Re: [PERFORM] Determining server load from client

2007-03-20 Thread Jim Buttafuoco
ing server load from client I've found that it would be helpful to be able to tell how busy my dedicated PG server is ( Linux 2.6 kernel, v8.0.3 currently ) before pounding it with some OLAP-type queries. Specifically, I have a multi-threaded client program that needs to run several

Re: [PERFORM] Determining server load from client

2007-03-20 Thread Dan Harris
Dan Harris wrote: I've found that it would be helpful to be able to tell how busy my dedicated PG server is ( Linux 2.6 kernel, v8.0.3 currently ) before pounding it with some OLAP-type queries. ..snip Thank you all for your great ideas! I'm going to try the perl function as that seems like

Re: [PERFORM] Determining server load from client

2007-03-20 Thread Joe Healy
(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 significan

Re: [PERFORM] Determining server load from client

2007-03-20 Thread Craig A. James
Dan Harris wrote: I've found that it would be helpful to be able to tell how busy my dedicated PG server is ... I have seen some other nice back-end things exposed through PG functions ( e.g. database size on disk ) and wondered if there was anything applicable to this. I'd write a simple p

[PERFORM] Determining server load from client

2007-03-20 Thread Dan Harris
I've found that it would be helpful to be able to tell how busy my dedicated PG server is ( Linux 2.6 kernel, v8.0.3 currently ) before pounding it with some OLAP-type queries. Specifically, I have a multi-threaded client program that needs to run several thousand sequential queries. I broke