Feature Request

Currently it's not possible to gather metrics per username (number of queries and so on) for mysql plugin

Proposal:

There is the table which contains desired information: performance_schema.events_statements_summary_by_account_by_event_name need to add this functionality to mysql plugin.
For example: add flag into config:
gather_perf_sum_per_acc_per_event = true
and we can filter by only desired events:
perf_summary_events = ["statement/sql/select", "statement/sql/update", "statement/sql/delete", "statement/sql/insert", "statement/sql/commit", "statement/sql/rollback", "statement/sql/savepoint"]

Current behavior:

absent

Desired behavior:

metrics from performance_schema.events_statements_summary_by_account_by_event_name is available on influxdb

Use case:

In system where lots of component it's hard to understand which component overuses resources. Will be very helpful for monitoring multi-component setup