[hobbit] - MySQL monitoring

[Francesco Duranti]

I'll check the script to understand what can be get and monitored from a mysql server for a next version of dbcheck. 
Thanks for the links :D

Francesco
 

> -----Original Message-----
> From: Great Dilla [mailto:great.dilla at gmail.com] 
> Sent: Tuesday, October 17, 2006 9:39 PM
> To: hobbit at hswn.dk
> Subject: Re: [hobbit] - MySQL monitoring
> 
> 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
> >
> >
> >
> 
> To unsubscribe from the hobbit list, send an e-mail to 
> hobbit-unsubscribe at hswn.dk
> 
> 
>