In this post, it’s mentioned that query latency increases on increasing mysql_query_rules record count.
10000 query rules are added for 10000 schema in same mysql machine with same data. Almost all the query took same time for execution which is contradictory to the mentioned doc.
Could be of great help if anyone could explain how to calculate the time taken for proxysql to select the host group. Tried global variable ‘Query_Processor_time_nsec’ which is sometimes 0.