Added support for Performance Schema metrics

[isartmontane]

If Performance_schema is enabled you will get the following metrics as well.

Number of connections per Account (host-user) - Total and current
Number of connections per User - Total and current
Number of connections per Host - Total and current
Number of rows read per index - schema, table, index name, rows read
Indexes not being used (didn't get any read) - schema, table, index_name
Queries that raised errors/warnings - Query, number of executions, errors, warnings
Slow queries - Query, number of executions, execution time (total,max,avg), rows sent (total, avg), scanned rows

[chrisboulton]

These are really sweet changes, and I think they would be super useful.

Before I merge down, would you consider making this an option people have to turn on? I can speak for our experience ($work), where we have many thousands of databases and users per server and collecting these metrics for each user would be near impossible.

[isartmontane]

Sure, give me a couple of weeks

On Thu, Aug 11, 2016 at 9:39 AM, Chris Boulton [email protected] wrote:

These are really sweet changes, and I think they would be super useful.

Before I merge down, would you consider making this an option people have to turn on? I can speak for our experience ($work), where we have many thousands of databases and users per server and collecting these metrics for each user would be near impossible.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/chrisboulton/collectd-python-mysql/pull/9#issuecomment-239092772, or mute the thread https://github.com/notifications/unsubscribe-auth/AAW805-RrKtW7T75RR_s1C_EeALCJ9y4ks5qetG8gaJpZM4GsLWw .

[KonstantinKuklin]

@isartmontane what`s the progress?

[hbani]

@isartmontane Can we priotize this? we are looking same for our use case

[isartmontane]

Hi! I'm sorry, but I don't have the environment to work on it any more.

Feel free to take that pull request and work on it to add the missing features if it gives you some value.

On Tue, May 10, 2022 at 8:39 PM hbani @.***> wrote:

Can we priotize this? we are looking same for our use case

— Reply to this email directly, view it on GitHub https://github.com/chrisboulton/collectd-python-mysql/pull/9#issuecomment-1122740105, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAC3ZU5D36OJNDNCA3ZUVQDVJKUPPANCNFSM4BVQWWYA . You are receiving this because you were mentioned.Message ID: @.***>