[hobbit] - MySQL monitoring

thomas.seglard.enata at cnp.fr thomas.seglard.enata at cnp.fr
Wed Oct 11 12:23:21 CEST 2006


Thanks for your script and the link, they are very useful... All are 
working perfectly. I will check the mysqlar site soon.
Best regards,

Thomas

mormonmatthew at gmail.com a écrit sur 10/10/2006 18:43:29 :

> 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/
> [rattachement "mysql-activity.tar.gz" supprimé par Thomas 
> SEGLARD/FI6/ANFI/CNP Assurances] To unsubscribe from the hobbit 
> list, send an e-mail to
> hobbit-unsubscribe at hswn.dk



Ce message (et toutes ses pieces jointes eventuelles) est confidentiel et etabli a l'intention exclusive de ses destinataires.
Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est
interdite, sauf autorisation expresse.
L'internet ne permettant pas d'assurer l'integrite de ce message, CNP Assurances et ses filiales declinent toute responsabilite
au titre de ce message, s'il a ete altere, deforme ou falsifie.

*****

This message and any attachments (the "message") are confidential and intended solely for the addressees.
Any unauthorised use or dissemination is prohibited.
E-mails are susceptible to alteration.
Neither CNP Assurances nor any of its subsidiaries or affiliates shall be liable for the message if altered, changed or falsified.




More information about the Xymon mailing list