I would like to use proxysql so that they can by itself redirect requests which will take too long to execute, I don't know if it's possible but I look no matter how hard I find anything. Someone would have any idea ?
Asked
Active
Viewed 228 times
0
-
Let's discuss why the query is taking so long. Please provide `SHOW CREATE TABLE`, `EXPLAIN SELECT...` and the value of `innodb_buffer_pool_size`. – Rick James Sep 28 '21 at 15:36
-
If I have to send all the `show create table` it’s going to be long, it’s often on a big request with many `inner join`, I’ll rather look for a solution with proxysql – Axel Morvan Sep 29 '21 at 08:15
-
The _client_ could bypass proxysql and connect to the Replica that is dedicated to long queries. – Rick James Sep 29 '21 at 16:56
-
Yes it would be a solution but the problem is how to identify the queries that pose problem automatically. – Axel Morvan Sep 30 '21 at 06:27
-
Are users making up arbitrary queries? How many Replicas do you have? – Rick James Sep 30 '21 at 15:23