[MDEV-17239] change default max_recursive_iterations = 4G -> 1k Created: 2018-09-19 Updated: 2021-03-30 Resolved: 2021-03-30 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Optimizer - CTE |
| Fix Version/s: | 10.6.0 |
| Type: | Task | Priority: | Major |
| Reporter: | Daniel Black | Assignee: | Daniel Black |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | defaults | ||
| Issue Links: |
|
||||||||
| Description |
|
I'm thinking 4G is a bit insane as a default. Certainly consumes a lot of CPU when you get your bounds wrong. Compared to the Oracle MySQL value [1] of 1000: [1] https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_cte_max_recursion_depth |
| Comments |
| Comment by Daniel Black [ 2020-03-13 ] |
|
Any thoughts as the last weeks of 10.5 beta are around? |
| Comment by Daniel Black [ 2020-10-01 ] |
|
Can we determine the maximum size based on the stack and autosize it if not set? |
| Comment by Daniel Black [ 2021-03-30 ] |
|
I have updated https://mariadb.com/kb/en/server-system-variables/ |