[mrtg] Re: Monitoring a MySQL DBMS

Daniel Curry dcurry at dollar.com
Thu Dec 2 16:50:32 MET 1999


Looks great.  I'll have to try it on my MySQL db @ home this weekend.
But does anyone have ideas on how to get similar data from OracleDB's?
I have noticed that the Oracle dbsnmp process runs on ports 1161 and
1162.  some direction in this woudl be greatly appreciated.



-----Original Message-----
From: Wolfgang Fiedler [mailto:fiedler at fiedler.vc-graz.ac.at]
Sent: Thursday, December 02, 1999 9:26 AM
Cc: mrtg at list.ee.ethz.ch
Subject: [mrtg] Re: Monitoring a MySQL DBMS


Wolfgang Fiedler wrote:
> 
> Hello all!
> 
> As we all know, mrtg has a nice feature and can gather
> information from external programs.
> 
> I want to monitor some information from my MySQL database server
> i.e.: number of querys, number of connectrions, number of running
> threads,...

Hello !

For anyone who is interested in monitoring a MySQL Database:

I played a litte bit with awk (you remember the first time ......
..with awk? ;-) )  and came up with this one-liner

mysqladmin extended-status -u root -pxxxxx | awk '/Questions/ { print $4
; print $4 ; print "a very long time" ; print "myhost.domain.at" }'

xxxxx should be the MySQL password of the user.
If you are interested in any other value, then substitute /Questions/
with  /Connections/ or /Threads_running/ or whatever...

If you use this in a production environment, then i suggest that you
create a MySQL User with only process privileges and don't use the
MySQL superuser account.


greetings

	wolfgang fiedler

-- 
************************************************************************
Wolfgang Fiedler http://fiedler.vc-graz.ac.at mailto:wfiedler at iicm.edu
Student of Telematics at Graz University of Technology, Austria, Europe
Institute f. Information Processing & Computer Supported New Media
(IICM)

--
* To unsubscribe from the mrtg mailing list, send a message with the
  subject: unsubscribe to mrtg-request at list.ee.ethz.ch
* The mailing list archive is at http://www.ee.ethz.ch/~slist/mrtg

--
* To unsubscribe from the mrtg mailing list, send a message with the
  subject: unsubscribe to mrtg-request at list.ee.ethz.ch
* The mailing list archive is at http://www.ee.ethz.ch/~slist/mrtg


More information about the mrtg mailing list