Re: Proposed changes to DTrace probe implementation - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: Proposed changes to DTrace probe implementation
Date
Msg-id 20080227092819.GH5916@svr2.hagander.net
Whole thread Raw
In response to Re: Proposed changes to DTrace probe implementation  (Robert Lor <Robert.Lor@Sun.COM>)
Responses Re: Proposed changes to DTrace probe implementation
List 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


pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Two Coverity Scan volunteers needed
Next
From: Dimitri Fontaine
Date:
Subject: Re: pg_dump additional options for performance