[MCOL-2223] Engine independent statistics for Columnstore Created: 2019-03-08  Updated: 2022-08-15  Resolved: 2022-08-15

Status: Closed
Project: MariaDB ColumnStore
Component/s: MDB Plugin
Affects Version/s: None
Fix Version/s: Icebox

Type: New Feature Priority: Major
Reporter: Roman Assignee: Roman
Resolution: Won't Do Votes: 0
Labels: Compatibility

Issue Links:
Duplicate
is duplicated by MCOL-126 analyze table/independent stats do no... Closed
Epic Link: ColumnStore Compatibility Improvements

 Description   

CS now has a very rudimentary query optimization capabilities and we want to improve the situtation. We consider to use Server's optimizer for the purpose but the Server needs statistics namely values distribution histograms and Number of Distinct Values distribution histograms.
There are different levels of complexity for the task:

  • implement standalone segment files reader that in the end populates both mysql.column_stats and mysql.table_stats using out of band mariadb client connection
  • implement ANALYZE TABLE functionality for Columnstore engine
  • implement ANALYZE TABLE and Histograms with equal-width bins for values distribution histograms(similar to MDEV-12313) together with NDV histograms to decrease I/O

We expect to have both unit and regression tests but this is optional.



 Comments   
Comment by Roman [ 2022-08-15 ]

MCS team decided to go with their own optimizer.

Generated at Thu Feb 08 02:34:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.