Bug #120575 Range optimizer chooses bad range plan for large IN lists and execution is very slow and memory usage spikes.
Submitted: 30 May 6:57 Modified: 4 Aug 14:17
Reporter: hel le Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S2 (Serious)
Version:8.0.41+ OS:Any
Assigned to: CPU Architecture:Any
Tags: Memory, Optimizer, performance, range_optimizer_max_mem_size, range-optimizer

Contributions can be accepted to Open bugs only.