Improve the article Managing MySQL long-running queries

Releem / mysqlconfigurer

Releem is a simple MySQL tuning tool to improve database performance and reduce servers costs.

https://releem.com

GNU General Public License v3.0

255 stars 27 forks source link

Open drupaladmin opened 1 month ago

drupaladmin commented 1 month ago

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;