Simple query performace is degraded between 5.4 and 5.5 (MCOL-4527)

[MCOL-4528] Analyze and explain the reasons for the difference between 5.4 and 5.5 Created: 2021-02-02  Updated: 2021-02-08  Resolved: 2021-02-08

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: None
Fix Version/s: 5.5.2

Type: Sub-Task Priority: Major
Reporter: Gregory Dorman (Inactive) Assignee: David Hall (Inactive)
Resolution: Done Votes: 0
Labels: None

Sprint: 2021-2, 2021-3

 Description   

Basic facts as known today:

  • Available traces show 2x elapsed time between 5.4 and 5.5
  • They also show 50% difference in LIO
  • This is almost certainly NOT extent elimination problem. The reason for this statement is that when this query was run using utf8, it did not do extent elimination, and the difference was close to 4x on elapsed and 3x on LIO.
  • Personal opinions point to CPU overhead of collations. But before this is positively determined - the difference in LIO needs to be explaind.
    REPEAT: this task is RESEARCH and diagnosis only. No solutions are to be proposed at this time.


 Comments   
Comment by David Hall (Inactive) [ 2021-02-08 ]

The analysis can be found here: https://docs.google.com/spreadsheets/d/1RtqIovT1kmU2G5iEmYBYF6O4CQRraeN_j0g5lrQBAIM/edit#gid=0

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