[MCOL-4849] Optimize ExeMgr to reduce a number of context switches Created: 2021-08-30 Updated: 2022-03-29 Resolved: 2021-11-17 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | ExeMgr |
| Affects Version/s: | 6.1.1 |
| Fix Version/s: | 6.2.2 |
| Type: | New Feature | Priority: | Major |
| Reporter: | Roman | Assignee: | Daniel Lee (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Attachments: |
|
||||||||
| Issue Links: |
|
||||||||
| Epic Link: | ColumnStore Performance Improvements | ||||||||
| Sprint: | 2021-10, 2021-11, 2021-12, 2021-13, 2021-14, 2021-15 | ||||||||
| Description |
|
MCS generates enourmous amount of context switches that degrades performance a lot. The screenshoot cs.png demonstates this, namely cs number raises from ~80 to 21k once I run a single query(select l_orderkey, count(l_orderkey) from lineitem group by l_orderkey limit 10) in an infinite loop.
|
| Comments |
| Comment by Daniel Lee (Inactive) [ 2021-11-17 ] | ||||||||||||||||||
|
Build tested: 6.2.2 (#3334, #3335) Build performance compared to release 6.1.1
Detailed performance test result can be found here: https://docs.google.com/spreadsheets/d/1tznQqmpKfkbnn4HjfjYIIeowJlQpNlHj8PVI6QM-3mc/edit?usp=sharing |