No query latency found in proxysql on increasing mysql query rules. Need confirmation on max mysql query rules that can be imposed in one proxysql instances

In this post, it’s mentioned that query latency increases on increasing mysql_query_rules record count.

Test set-up
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.

Thanks ahead!

1 Like