Are there any statistics available in ProxySQL that show the total count per hostgroup (or per server)?
SELECT rule_id, hits, destination_hostgroup FROM mysql_query_rules NATURAL JOIN stats_mysql_query_rules; does show statistics per rule, but it does not provide information on how many queries are actually sent to each hostgroup. Additionally, the Questions metric from stats_mysql_global only shows the total number of statements executed, without distinguishing between hosts or hostgroups.
SELECT hostgroup, COUNT(*) AS query_count FROM stats_mysql_query_digest GROUP BY hostgroup; does not seem to display the total count. Or am I missing something?