[mrtg] Re: Monitoring Mysql

[Ronnie Garcia]

Hoy,

  It was already discussed in this list, please grep the archive for 'mysql' .

  Ok, since i'm a cool guy, i did it for you and here is what wolfgang 
fiedler said:

---
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.
---

At 09:20 01/03/00 -0500, Nicholas Ascione wrote:
>Has anyone ever used mrtg to monitor a mysql db. If so, how
>do you do this and do you have any sample code in perl ?
>
>Thanks,
>Nick


-------------

   - Nétia -
Halle Industrielle de Farjou - 34270 Claret
Tél: +33 (0)4 67 590 807
Fax: +33 (0)4 67 590 820

  www.netia.net

--
Unsubscribe mailto:mrtg-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:mrtg-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/mrtg