[mrtg] Monitoring a MySQL DBMS

[Wolfgang Fiedler]

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

the output of the command

fiedler:~ # mysqladmin extended-status -u root -pxxxxxxx
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| Aborted_clients          | 0     |
| Aborted_connects         | 0     |
| Connections              | 5     |
| Created_tmp_tables       | 0     |
| Delayed_insert_threads   | 0     |
| Delayed_writes           | 0     |
| Delayed_errors           | 0     |
| Flush_commands           | 1     |
| Handler_delete           | 0     |
| Handler_read_first       | 1     |
| Handler_read_key         | 0     |
| Handler_read_next        | 0     |
| Handler_read_prev        | 0     |
| Handler_read_rnd         | 0     |
| Handler_read_rnd_next    | 18    |
| Handler_update           | 0     |
| Handler_write            | 0     |
| Key_blocks_used          | 0     |
| Key_read_requests        | 0     |
| Key_reads                | 0     |
| Key_write_requests       | 0     |
| Key_writes               | 0     |
| Max_used_connections     | 0     |
| Not_flushed_key_blocks   | 0     |
| Not_flushed_delayed_rows | 0     |
| Open_tables              | 2     |
| Open_files               | 4     |
| Open_streams             | 0     |
| Opened_tables            | 6     |
| Questions                | 7     |
| Slow_queries             | 0     |
| Threads_connected        | 1     |
| Threads_running          | 1     |
| Uptime                   | 5704  |
+--------------------------+-------+

Has somebody written such a program or shell-script for mrtg to
monitor such information??
I don't want to reinvent the weel (OK,OK, sed and grep and such
useful progs are not my friends)

Thanks for any input

	Wolfgang Fiedler


PS:  mrtg is really a great! (I'm currently monitoring our 3Com
Superstack
Switch, my SQUID Cache and my Linux Server)


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