Re: Proposed changes to DTrace probe implementation

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Robert Lor <Robert(dot)Lor(at)Sun(dot)COM>
Cc: Gregory Stark <stark(at)enterprisedb(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Proposed changes to DTrace probe implementation
Date: 2008-02-27 09:28:19
Message-ID: 20080227092819.GH5916@svr2.hagander.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Feb 26, 2008 at 03:48:28PM -0600, Robert Lor wrote:
> Gregory Stark wrote:
> >I think both types of probes are useful to different people.
> >
> I think certain higher level probes can be really useful to DBAs.
> >Perhaps looking at the standard database SNMP MIB counters would give us a
> >place to start for upward facing events people want to trace for databases
> >in
> >general.
> >
> Great idea. I found this link for public RDBMS MIB
> http://www.mnlab.cs.depaul.edu/cgi-bin/sbrowser.cgi?HOST=&OID=RDBMS-MIB!rdbmsMIB
>
> The stats in rdbmsSrvInfoTable is quite useful, and it's one of the
> tables that Oracle implements in their SNMP support.
> http://download-east.oracle.com/docs/cd/B14099_19/manage.1012/b16244/appdx_d_rdbms.htm

Incidentally, most of that's already supported by the pg snmp provider,
through the stats system.

//Magnus

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dimitri Fontaine 2008-02-27 09:52:47 Re: pg_dump additional options for performance
Previous Message Martijn van Oosterhout 2008-02-27 08:19:07 Re: Two Coverity Scan volunteers needed