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
I suspect this data being correctly graphed is version specific, or perhaps the script is not correctly picking up the variables from mysql.
I'm not sure. You could try picking apart the MySQL script and making sure it pulls the correct data. :)
adam.
On 2013-07-22 18:15, Shaun Bradley wrote:
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 _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
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.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
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
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
Ah, I've noticed the exact same graphs don't work on your demo site too. At least it's not an isolated problem. Hmm.
http://demo.observium.org/device/device=6/tab=apps/app=mysql/app_section=inn...
Shaun Bradley Marketing Source shaun.bradley@marketingsource.co.uk
From: observium [mailto:observium-bounces@observium.org] On Behalf Of Shaun Bradley Sent: 24 July 2013 11:13 AM To: Observium Network Observation System Subject: Re: [Observium] Certain MySQL agent graphs not showing
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
It seems that half of the applications graphs were re-using $vars which clashed with pretty much the entire web interface.
I've changed the variable name and all of those MySQL graphs are drawing again.
adam.
On 2013-08-02 12:22, Shaun Bradley wrote:
Ah, I've noticed the exact same graphs don't work on your demo site too. At least it's not an isolated problem. Hmm.
http://demo.observium.org/device/device=6/tab=apps/app=mysql/app_section=inn... [1]
Shaun Bradley
Marketing Source
shaun.bradley@marketingsource.co.uk
FROM: observium [mailto:observium-bounces@observium.org] ON BEHALF OF Shaun Bradley SENT: 24 July 2013 11:13 AM TO: Observium Network Observation System SUBJECT: Re: [Observium] Certain MySQL agent graphs not showing
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 J
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
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.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
Links:
[1] http://demo.observium.org/device/device=6/tab=apps/app=mysql/app_section=inn...
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Nice work, displaying here now too. Many thanks.
-----Original Message----- From: observium [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong Sent: 02 August 2013 12:51 PM To: Observium Network Observation System Subject: Re: [Observium] Certain MySQL agent graphs not showing
It seems that half of the applications graphs were re-using $vars which clashed with pretty much the entire web interface.
I've changed the variable name and all of those MySQL graphs are drawing again.
adam.
On 2013-08-02 12:22, Shaun Bradley wrote:
Ah, I've noticed the exact same graphs don't work on your demo site too. At least it's not an isolated problem. Hmm.
http://demo.observium.org/device/device=6/tab=apps/app=mysql/app_secti on=innodb/ [1]
Shaun Bradley
Marketing Source
shaun.bradley@marketingsource.co.uk
FROM: observium [mailto:observium-bounces@observium.org] ON BEHALF OF Shaun Bradley SENT: 24 July 2013 11:13 AM TO: Observium Network Observation System SUBJECT: Re: [Observium] Certain MySQL agent graphs not showing
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 J
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
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.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
Links:
[1] http://demo.observium.org/device/device=6/tab=apps/app=mysql/app_secti on=innodb/
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (3)
-
Adam Armstrong -
Shaun Bradley -
Thomas Raabo - Zitcom A/S