Bug #117244 range_optimizer_max_mem_size

• Submitted: 20 Jan 9:49
• Modified: 20 Jan 16:07
• Reporter: gang chen (OCA)
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 8.0, 9.0,9.1, 8.4
• OS: Any
• CPU Architecture: Any

[20 Jan 9:49] gang chen

Description:
Hello MySQL Team

I have been using Server System Variables recently:Server System Variables： range_optimizer_max_mem_size , I found that the manual states that this variable does not support set_var, but in my actual operation, this variable is supported.

https://dev.mysql.com/doc/refman/9.1/en/server-system-variables.html#sysvar_range_optimize...

How to repeat:
select /*+set_var(range_optimizer_max_mem_size=500)*/ @@range_optimizer_max_mem_size  ;

Suggested fix:
this variable SET_VAR Hint Applies is Yes

[20 Jan 9:52] MySQL Verification Team

Hello gang chen,

Thank you for the report and feedback.

regards,
Umesh

[20 Jan 16:07] Edward Gilmore

Posted by developer:
 
range_optimizer_max_mem_size documentation updated as requested.
Thank you for the bug report.