search

kjellm / munin-mysql

Improved MySQL Graphs for Munin
http://oierud.net/bliki/ImprovedMuninGraphsForMySQL.html
GNU General Public License v2.0
156 stars 47 forks source link

Label trouble in query cache graphs #39

Closed Synchro closed 13 years ago

Synchro commented 13 years ago

I'm getting this logged in munin-update.log from several servers:

2011/06/24 09:00:09 [WARNING] Service innodb_insert_buf on www.example.com/192.168.0.10:4949 returned no data for label ib_ibuf_merged_rec
2011/06/24 09:00:09 [WARNING] Service innodb_insert_buf on www.example.com/192.168.0.10:4949 returned no data for label ib_ibuf_inserts
2011/06/24 09:00:09 [WARNING] Service innodb_insert_buf on www.example.com/192.168.0.10:4949 returned no data for label ib_ibuf_merges
2011/06/24 09:00:09 [WARNING] Service caches on www.example.com/192.168.0.10:4949 returned no data for label bcu
2011/06/24 09:00:09 [WARNING] Service caches on www.example.com/192.168.0.10:4949 returned no data for label bl_cache_eff
2011/06/24 09:00:09 [WARNING] Service caches on www.example.com/192.168.0.10:4949 returned no data for label qcache_eff
2011/06/24 09:00:09 [WARNING] Service caches on www.example.com/192.168.0.10:4949 returned no data for label krrd
2011/06/24 09:00:09 [WARNING] Service caches on www.example.com/192.168.0.10:4949 returned no data for label key_cache_eff
2011/06/24 09:00:09 [WARNING] Service caches on www.example.com/192.168.0.10:4949 returned no data for label bcdu
2011/06/24 09:00:09 [WARNING] Service caches on www.example.com/192.168.0.10:4949 returned no data for label qh
2011/06/24 09:00:09 [WARNING] Service caches on www.example.com/192.168.0.10:4949 returned no data for label cs
2011/06/24 09:00:09 [WARNING] Service caches on www.example.com/192.168.0.10:4949 returned no data for label krd

I'm also getting these, whose names seem to overlap with the above:

2011/06/24 09:10:24 Missing required attribute 'label' for data source 'Com_select' in service caches on db2.example.net/192.168.0.11:4949
2011/06/24 09:10:24 Missing required attribute 'label' for data source 'bcu' in service caches on db2.example.net/192.168.0.11:4949
2011/06/24 09:10:24 Missing required attribute 'label' for data source 'Key_read_requests' in service caches on db2.example.net/192.168.0.11:4949
2011/06/24 09:10:24 Missing required attribute 'label' for data source 'krrd' in service caches on db2.example.net/192.168.0.11:4949
2011/06/24 09:10:24 Missing required attribute 'label' for data source 'Binlog_cache_disk_use' in service caches on db2.example.net/192.168.0.11:4949
2011/06/24 09:10:24 Missing required attribute 'label' for data source 'Binlog_cache_use' in service caches on db2.example.net/192.168.0.11:4949
2011/06/24 09:10:24 Missing required attribute 'label' for data source 'Key_reads' in service caches on db2.example.net/192.168.0.11:4949
2011/06/24 09:10:24 Missing required attribute 'label' for data source 'bcdu' in service caches on db2.example.net/192.168.0.11:4949
2011/06/24 09:10:24 Missing required attribute 'label' for data source 'qh' in service caches on db2.example.net/192.168.0.11:4949
2011/06/24 09:10:24 Missing required attribute 'label' for data source 'cs' in service caches on db2.example.net/192.168.0.11:4949
2011/06/24 09:10:24 Missing required attribute 'label' for data source 'krd' in service caches on db2.example.net/192.168.0.11:4949
2011/06/24 09:10:24 Missing required attribute 'label' for data source 'Qcache_hits' in service caches on db2.example.net/192.168.0.11:4949

Though there seem to be quite a few of these, the only graphs that are not working are query cache and cache efficiency. I'm on Percona Server 5.5.12 - Is this likely to be another thing down to differences in Percona server output?

kjellm commented 13 years ago

Hi, thank you for reporting the issue.

The warnings concerning the innodb_insert_buf graph are known (see discussion in #34). They are caused by a new format in SHOW ENGINE INNODB STATUS output in MySQL 5.5 (so not caused by percona).

The rest of the warnings are from the caches graph. This graph is a contribution and not really supported by me. I have changed the Makefile to not install contributed graphs by default. If you don't care for the graph, you can just delete it from.

`perl '-V:installsitelib'|cut -d"'" -f2`/Munin/MySQL/Graph/CacheEfficiency.pm

Or you can try contact the graph author at mrten+munin@ii.nl.