Bug #83172 Add ability to pass session variables as optimizer hint

• Submitted: 27 Sep 2016 12:51
• Modified: 13 Mar 2019 11:50
• Reporter: Sveta Smirnova (OCA)
• Status: Closed
• Category: MySQL Server: Optimizer
• Severity: S4 (Feature request)
• Version: 5.7, 8.0
• OS: Any
• CPU Architecture: Any
• Tags: Contribution

[27 Sep 2016 12:51] Sveta Smirnova

Description:
Optimizer hints is great feature, but sometimes users need to change session variables, such as join_buffer_size, per-query too. Would be good if optimizer hints allow this possibility.

See also slides 21-35 at http://www.slideshare.net/SvetaSmirnova/preparse-query-rewrite-plugins

You can use code from https://github.com/svetasmirnova/custom_hint_plugin

OCA signed today

How to repeat:
See description

[29 Sep 2016 7:19] MySQL Verification Team

Hello Sveta,

Thank you for the feature request and contribution.

Thanks,
Umesh

[13 Mar 2019 11:50] Norvald Ryeng

Posted by developer:
 
Implemented as WL#681 in MySQL 8.0.3.