Well, I've run the mysql agent manually, setting the debug file output and I've noticed the missing graph variable names are returning '-1' for that variable, but in the debug log it looks like everything is getting information. Logging in as the observium_mon user and running the 'show innodb status' commands and suchlike does actually return information so I'm not sure if the agent is doing something weird. Either that or it's me :)
Shaun
From: observium [mailto:observium-bounces@observium.org] On Behalf Of Shaun Bradley Sent: 23 July 2013 09:08 AM To: Observium Network Observation System Subject: Re: [Observium] Certain MySQL agent graphs not showing
On 4210 here and it's a pretty fresh install, only a few versions back. Your stated fix did bring a few more graphs up though, unless that was just the polling overnight. Perhaps I'll wait a few days longer to see if any other graphs appear. I'm missing a few on the 'queries' and 'innodb' pages too.
Shaun
From: observium [mailto:observium-bounces@observium.org] On Behalf Of Thomas Raabo - Zitcom A/S Sent: 22 July 2013 10:20 PM To: Observium Network Observation System Subject: Re: [Observium] Certain MySQL agent graphs not showing
Same problem here.
Med venlig hilsen | Best regards Thomas Raabo Senior Network Engineer CCIE #33466
[Beskrivelse: Beskrivelse: cid:image001.jpg@01CB9163.2FCD3AC0] _____________________________________________ tr@zitcom.dkmailto:tr@zitcom.dk | Direkte: +45 69 10 60 18 | Tlf.: +45 70 23 55 66
From: observium [mailto:observium-bounces@observium.org] On Behalf Of Shaun Bradley Sent: 22. juli 2013 18:15 To: observium@observium.orgmailto:observium@observium.org Subject: [Observium] Certain MySQL agent graphs not showing
Hi,
Once again it's me. I have the mysql and apache agents running on a few machines and have observium picking the data up. This is working fine for apache and mostly for mysql, but I have missing graphs for 'process list' 'myisam indexes' (our dbs are mainly innodb based), table locks, and temporary objects. I have followed the agent instructions to a tee as far as I can see and have double checked my configuration, as well as googled for any info, but I am stuck on this one.
Is there any way I can either remove these broken graph links or fill out the information? I can't see what I'd change to make them appear to be honest.
Any pointers would be gratefully received.
Thanks,
Shaun
