您好,欢迎来到三六零分类信息网!老站,搜索引擎当天收录,欢迎发信息

Munin graphing of MySQL_MySQL

2024/5/12 3:33:55发布43次查看
while there are many graphing tools out there and we’ve used munin for a while now.
the mysql plugin for munin had fallen out of date and the show engine innodb status  output changed in 5.5 making some bits of the plugin simply not work any more. also the show global status has some extra variables so there was a need to create new graphs.
all of these are now in the 2.1.8 + development releases of munin.
here are samples of the new/updated graphs.
tables
table definitions
innodb buffer pool activity
innodb buffer pool internal breakdown
innodb insert buffer
innodb buffer pool
innodb semaphores
innodb master thread
innodb adaptive hash index
innodb queries and transactions
innodb read views
innodb descriptors
performance schema losses
query cache
maximum memory of mysql
rows
handler read
handler transaction
handler write
handler temporary write/updates
execution (triggers and events)
index condition pushdown
multi range read optimizations
some of these above graphs may miss a variable or two with mariadb-10 because of variable name changes. these will be corrected when we get to those. in mariadb-10 there is useful transition to information schema tables for status information which will make it significantly easier to parse.
individual buffer pool information also has been parsed out however we haven’t worked out how to graphing this correctly. also not yet merged is a bunch of galera graphs which are currently waiting on some galera provider changes.
we’ll continue to work with the munin developers to keep this mysql plugin up to date and useful.
there’s other graphs in the mysql munin plugins that we haven’t changed so aren’t included here.
该用户其它信息

VIP推荐

免费发布信息,免费发布B2B信息网站平台 - 三六零分类信息网 沪ICP备09012988号-2
企业名录 Product