Register and ask your own question!
I see the following error in my java application logs
SqlExceptionHelper:146 - Query execution was interrupted, query_timeout exceeded
I tried to manually to run the following fix in all the proxysql pods
update global_variables set variable_value = 86400000 where variable_name = 'mysql-default_query_timeout';
but the error still exist and the action behind it takes few seconds to load and finish.
Do you know a solution to fix this error.
Also, how can I edit the proxysql configurations so I don't have to do it manually at each pod?