On 10/10/06, user-bb3e9041f07f@xymon.invalid <user-bb3e9041f07f@xymon.invalid> 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/