MySQL max_execution_time not working

Asked Nov 24 '20 at 16:01

Active Nov 24 '20 at 16:01

Viewed 348 times

We have a general problem with MySQL 8 running on Windows 2019. We see queries running forever and the CPU is 100%, the system becomes unresponsive.

While we know this needs a better investigation to be solved, and we're looking for a database expert to help us, for now, we are trying to solve this by having:

max_execution_time=30000

But this is not respected. Queries run for several minutes.

Why is this happening?

Thanks Alex

asked Nov 24 '20 at 16:01

Alex K.

btw if you are a database expert and want to work with us please contact me at alex [at] ndros [dot] com – Alex K. Nov 24 '20 at 16:03
Please check your email - including spam. – Wilson Hauck Nov 24 '20 at 20:28
1

Show us a slow query, including `SHOW CREATE TABLE` and `EXPLAIN SELECT...` – Rick James Nov 28 '20 at 02:12

MySQL max_execution_time not working

0 Answers0