[hobbit] - MySQL monitoring

Matthew Davis matthew at familycampground.org
Tue Oct 10 18:43:29 CEST 2006


On 10/10/06, thomas.seglard.enata at cnp.fr <thomas.seglard.enata at cnp.fr> wrote:
> I'm just asking you how do you monitor your MySQL databases ? I've setted

Attached is a script I wrote up one night based off MySQL Activity
Report (http://gert.sos.be/en/projects/mysqlar/).  Can't guarantee
it'll work, but it works for me with 4.1.21.

It does the following:

- max connections vs threads connected
- (Questions / Selects / Inserts / Updates / Deletes) per minute
- Table Cache vs Open Tables
- Created Tmp Tables vs Tmp Disk Tables  <-- logic is wrong here I
know I need to fix this

It was my 2nd hobbit script, so please let me know where I can improve.

-- 
Matthew Davis
http://familycampground.org/matthew/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mysql-activity.tar.gz
Type: application/x-gzip
Size: 2231 bytes
Desc: not available
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20061010/55b665db/attachment.bin>


More information about the Xymon mailing list