Skip to content
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.

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

Feature: support SET_VAR hints #8833

Closed
sundy-li opened this issue Nov 17, 2022 · 1 comment · Fixed by #11208
Closed

Feature: support SET_VAR hints #8833

sundy-li opened this issue Nov 17, 2022 · 1 comment · Fixed by #11208
Labels
C-feature Category: feature

Comments

@sundy-li
Copy link
Member

Summary

Description for this feature.

https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html

SELECT /*+ SET_VAR(sort_buffer_size = 16M) */ name FROM people ORDER BY name;
INSERT /*+ SET_VAR(foreign_key_checks=OFF) */ INTO t2 VALUES(2);
SELECT /*+ SET_VAR(optimizer_switch = 'mrr_cost_based=off') */ 1;
@sundy-li sundy-li added the C-feature Category: feature label Nov 17, 2022
@wubx
Copy link
Member

wubx commented Dec 29, 2022

Processing some simple SQL requires more concurrency:

select /*+ set_var(max_threads=1) */ name FROM people ORDER BY name;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-feature Category: feature
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants