Add support for INNODB_METRICS

[grypyrg]

It would be good to add support for information_schema.INNODB_METRICS: http://dev.mysql.com/doc/refman/5.6/en/innodb-metrics-table.html

[art-spilgames]

Thanks for the suggestion!
I'm going to pick this up today and see how easy it should/would be to implement something different than key/value.

[thijsdezoete]

@art-spilgames I'm looking forward to your findings! :)

[art-spilgames]

Hi Kenny,

I actually got it working in a crude way by adding only a few lines to the config in the mysql section:
stats_types = innometrics
query_innometrics = select NAME,COUNT from information_schema.INNODB_METRICS where STATUS='enabled'
interval_innometrics = 10000

This should enable you to pick up the metrics under the innometrics container but you should be able to rename it to any container you like.

There is a ton of other information in the innodb_metrics, but the question is how to make use of that. We could implement a preprocessor for the innodb_metrics table, however then we need to have a clear idea what metrics would be interesting.

[thijsdezoete]

hi @grypyrg,

Could you let us know if @art-spilgames's suggestion solved the problem?

[grypyrg]

I don't necessarily have a problem that needs to be resolved. Just want to make sure that the necessary data is collected.

It's great that this can be solved with some configuration.
Can this be enabled by default so those metrics are collected automatically?

I think count is enough. The other columns look less interesting to me.

[art-spilgames]

Currently there is no logic in the application about which versions support what metrics as we wanted it to keep it as simple as possible.
Perhaps a good idea to make a couple of sample configs per MySQL version and functionality?

[thijsdezoete]

👍

[grypyrg]

I can try to help and find out. I'll add it to my todo list, but it won't have big priority so might take a while.