Improve the article Managing MySQL long-running queries

[drupaladmin]

Don't forget that since MySQL 8.0 you can also modify the configuration without editing the my.cnf file:

SQL> set persist max_execution_time=20;

And you can also use the max_execution_time without changing any session or global variable but using optimizer hints like:

SELECT /*+ MAX_EXECUTION_TIME(1000) */ name, job from t1;

The source: https://dev.to/lefred/comment/2h21c