[hobbit] - MySQL monitoring

[Great Dilla]

How about using mysqlreport? (http://hackmysql.com/mysqlreport)

It could run as cgi-bin script probably in the hobbit server itself or
the client. It requires perl and the appropriate DBI modules.

I'm looking into incorporating replication slave monitoring into the script.

On 10/11/06, thomas.seglard.enata at cnp.fr <thomas.seglard.enata at cnp.fr> wrote:
> Hi Francesco,
>
> I'm sorry, I missed the new version and the query engine. I will try to
> look at it soon.
> Best regards,
>
> Thomas
>
> "Francesco Duranti" <fduranti at q8.it> a écrit sur 10/10/2006 21:16:24 :
>
> > You can use also dbcheck.pl to track the mysql database (connection and
> > same stats as the normal sqlstatus script).
> > The new version also has a custom query engine so it's possible to write
> > to query to analyze and if someone know how to get more data out of
> > sqlserver with query or sql command I can arrange some more checks for
> > it (and graphs also...).
> >
> > Francesco
> >
> >
> > > -----Original Message-----
> > > From: thomas.seglard.enata at cnp.fr
> > > [mailto:thomas.seglard.enata at cnp.fr]
> > > Sent: Tuesday, October 10, 2006 5:09 PM
> > > To: hobbit at hswn.dk
> > > Subject: [hobbit] - MySQL monitoring
> > >
> > > Hi,
> > >
> > > I'm just asking you how do you monitor your MySQL databases ?
> > > I've setted up the bb-mysqlstatus.sh and modify it to support
> > > NCV format. Now I got graphs for queries/sec and slowqueries.
> > > That's cool but it's not very accurate... I'm using MySQL
> > > Administrator from
> > > http://dev.mysql.com/downloads/gui-tools/5.0.html and results
> > > are not the same. Did you write something to track insert,
> > > select, etc. from 'mysqladmin extended-status' ? Thanks for
> > > your help !
> > > Sincerly,
> > >
> > > Thomas
> > >
> > >
> > > 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.
> > >
> > >
> > > To unsubscribe from the hobbit list, send an e-mail to
> > > hobbit-unsubscribe at hswn.dk
> > >
> > >
> > >
> >
> > 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.
>
>
> To unsubscribe from the hobbit list, send an e-mail to
> hobbit-unsubscribe at hswn.dk
>
>
>