In this post, I am going to show you how you can minimize the
performance impact of ProxySQL rules by using some finesse.
Apply Test
In my previous post, we could see the effect of the
rules on ProxySQL performance. As we could also see, the “apply”
option does not help with 1000 tables. Are we sure about this?
Let’s consider: if we know 90% of our traffic won’t match any
rules, it doesn’t matter if we have 10 or 500 rules – it has to
check all of them. And this is going to have a
serious effect on performance. How can we avoid that?
Let’s insert rule number ONE, which matches all queries, like
this:
insert into mysql_query_rules (username,destination_hostgroup,active,retries,match_digest,apply) values('testuser_rw',600,1,3,'(from|into|update|into table) …[Read more]