Implement one or more commands to reset statistics counters

[renecannao]

Counters on query rules are automatically reset when LOAD MYSQL QUERY RULES TO RUNTIME is executed.
Yet, there is not a way to reset counters on stats_mysql_commands_counters

[renecannao]

Implement table stats_mysql_commands_counters_reset

[hujiko]

Is there a somehow estimated date when this might be available?
This would be really useful for us.

Background:
We would like to regularly fetch the information from this table and put it into a StatsD.
Displaying this information on a graph would allow us to identify query time patterns and how they change over time. When using the stats_mysql_commands_counters table, the graphs would just increase until proxySQL is restarted. Sure, we can issue the LOAD MYSQL QUERY RULES TO RUNTIME command, but as you already stated: This is very hacky and can have some unwanted side effects. Plus: For our current ProxySQL version 1.4.14-percona-1.1, codename Truls this trick does not work at all. The stats are still available after reloading the query rules.

Or can you give us some hint about other ways we would be able to achieve this metrics?

Thanks a lot