[MDEV-17422] Fix documentation on split_grouping_derived and split_materialized Created: 2018-10-10  Updated: 2020-08-25  Resolved: 2018-10-11

Status: Closed
Project: MariaDB Server
Component/s: Documentation - Support, Optimizer
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None


 Description   

MariaDB 10.3 supposedly added a new optimization related to derived tables:

New optimizer switch setting, split_grouping_derived=on (see description)

https://mariadb.com/kb/en/library/changes-improvements-in-mariadb-103/#optimizerperformance

split_grouping_derived=on MariaDB 10.3.1

https://mariadb.com/kb/en/library/optimizer-switch/#available-flags

However, at some point, the split_grouping_derived optimizer_switch was removed, and it was replaced with split_materialized. The documentation was never updated.



 Comments   
Comment by Geoff Montee (Inactive) [ 2018-10-10 ]

psergey and igor can probably provide details on exactly when this change was made.

Comment by Sergei Petrunia [ 2018-10-12 ]

GeoffMontee, here's the change that made it: https://github.com/MariaDB/server/commit/4f0299f8b3cf19c103138ff656a37c1f672e9de6 . That page shows it was done in 10.3.4.

Generated at Thu Feb 08 08:36:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.