Optimize query and configure ProxySQL or MaxScale in MariaDB server
Budget: $25 – $50 USD
I have a query that is taking 4-5 seconds to finish in mytop. This query is running multiple times at the same time and because of this is generating a slow load behavior in our backend. I need you to find if it's possible to optimize the query so it runs faster by either adding extra index or tweaking the MariaDB config. If none of that works I will need to setup either ProxySQL or MaxScale to cache this query and prevent to generate CPU usage and generating the slow load behavior explained above.
No server access will be given, you will need to work through me.
No server access will be given, you will need to work through me.