New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Improve the article Managing MySQL long-running queries #333

Open

drupaladmin opened this issue Aug 2, 2024 · 0 comments

Contributor

drupaladmin commented Aug 2, 2024

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment