[MDEV-31964] Unexpected performance issue, Join_buffer_space_limit becomes smaller, but the query speed is faster Created: 2023-08-20 Updated: 2023-09-04 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Optimizer |
| Affects Version/s: | 11.0.3 |
| Fix Version/s: | 11.0 |
| Type: | Bug | Priority: | Major |
| Reporter: | fuying | Assignee: | Oleg Smirnov |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Environment: |
docker mariadb:11.0 |
||
| Attachments: |
|
| Description |
|
When Join_buffer_space_limit is set to the minimum value, the query speed is increased dozens of times, which is unreasonable. Steps to reproduce: But when performing the same steps 1 and 2, and before performing step 3, SET Session join_buffer_space_limit = 2048; Theoretically, `join_buffer_space_limit` is merely an upper limit, and a larger value should result in faster query speeds. |