[hobbit] - MySQL monitoring

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/