[MCOL-5460] concurrent CTE operation excessive mutex - Jira

Details

Type: Bug
Status: Stalled (View Workflow)
Priority: Critical
Resolution: Unresolved
Affects Version/s: 23.02.1
Fix Version/s: 23.10
Component/s: None
Labels:
- rm_perf

Sprint:
2023-8, 2023-10, 2023-11, 2023-12, 2024-1, 2024-2

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Columnstore-CTE-Test-Results.zip
8 kB
2023-10-30 21:00
CTE1-23_10_0.png
127 kB
2023-11-01 17:24
CTE1-3-patches.png
104 kB
2023-11-01 17:24
CTE2-23_10_0.png
135 kB
2023-11-01 17:24
CTE2-3-patches.png
120 kB
2023-11-01 17:24
CTE3-23_10_0.png
99 kB
2023-11-01 17:24
CTE3-3-patches_2.png
104 kB
2023-11-01 17:24
CTE3-3-patches.png
97 kB
2023-11-01 17:24
screenshot-1.png
174 kB
2023-04-03 17:34
screenshot-2.png
182 kB
2023-04-03 17:40
screenshot-3.png
202 kB
2023-04-03 19:38
screenshot-4.png
196 kB
2023-04-03 19:39

Issue Links

includes

MCOL-5472 CPU wastes time in wait and sys b/c of urandom access in RowStorage.

Closed

MCOL-5473 Mutex lock contention doing VSS lookup loading a block

Stalled

MCOL-5474 Mutex lock contention doing block cache lookup when loading a block

Stalled

MCOL-5601 Config::makeConfig bottlenecks on a mutex contributing to CPU burned in sys

Closed

Activity

Ascending order - Click to sort in descending order

alexey vorovich (Inactive) created issue - 2023-03-21 15:48

Chris Calender (Inactive) made changes - 2023-03-22 18:43

Field	Original Value	New Value
Link		This issue relates to MCOL-4593 [ MCOL-4593 ]

Roman added a comment - 2023-03-22 20:44

bbancroft CSV is OK.

Roman added a comment - 2023-03-22 20:44 bbancroft CSV is OK.

alexey vorovich (Inactive) made changes - 2023-03-24 17:45

Fix Version/s

23.02.2 [ 28713 ]

alexey vorovich (Inactive) made changes - 2023-03-24 17:45

Assignee

Roman [ drrtuy ]

alexey vorovich (Inactive) made changes - 2023-03-24 17:45

Status

Open [ 1 ]

In Progress [ 3 ]

alexey vorovich (Inactive) added a comment - 2023-03-24 17:46

leonid.fedorov we need to connect PR to this ticket

alexey vorovich (Inactive) added a comment - 2023-03-24 17:46 leonid.fedorov we need to connect PR to this ticket

alexey vorovich (Inactive) made changes - 2023-03-24 17:52

Labels

mcs_cs_spendhq

Todd Stoffel (Inactive) made changes - 2023-03-29 21:25

Rank

Ranked higher

Todd Stoffel (Inactive) made changes - 2023-03-29 22:08

Rank

Ranked lower

Leonid Fedorov made changes - 2023-03-30 15:47

Status

In Progress [ 3 ]

In Testing [ 10301 ]

Daniel Lee (Inactive) made changes - 2023-04-02 01:26

Assignee

Roman [ drrtuy ]

Allen Herrera [ JIRAUSER48651 ]

Allen Herrera made changes - 2023-04-03 17:34

Attachment

screenshot-1.png [ 69365 ]

Allen Herrera made changes - 2023-04-03 17:40

Attachment

screenshot-2.png [ 69366 ]

alexey vorovich (Inactive) added a comment - 2023-04-03 18:17

allen.herrera So did we recover the overall performance of concurrent queries enough ?

alexey vorovich (Inactive) added a comment - 2023-04-03 18:17 allen.herrera So did we recover the overall performance of concurrent queries enough ?

alexey vorovich (Inactive) added a comment - 2023-04-03 18:47

The key here is to estimate what regression in timing (or improvements) we have after the recent fixes as compared to 611

alexey vorovich (Inactive) added a comment - 2023-04-03 18:47 The key here is to estimate what regression in timing (or improvements) we have after the recent fixes as compared to 611

Allen Herrera made changes - 2023-04-03 19:38

Attachment

screenshot-3.png [ 69368 ]

Allen Herrera made changes - 2023-04-03 19:39

Attachment

screenshot-4.png [ 69369 ]

Roman added a comment - 2023-04-03 22:52

I need an access to the machines to see where is the bottleneck.

Roman added a comment - 2023-04-03 22:52 I need an access to the machines to see where is the bottleneck.

Todd Stoffel (Inactive) made changes - 2023-04-04 00:21

Priority

Critical [ 2 ]

Blocker [ 1 ]

Leonid Fedorov added a comment - 2023-04-04 00:30

allen.herrera when you are referring 23.08.x release, that doesn't exist. Are you mentioning out last 23.02.2 package or 22.08.8? There is significant difference here

Leonid Fedorov added a comment - 2023-04-04 00:30 allen.herrera when you are referring 23.08.x release, that doesn't exist. Are you mentioning out last 23.02.2 package or 22.08.8? There is significant difference here

Daniel Lee (Inactive) made changes - 2023-04-04 14:48

Assignee

Allen Herrera [ JIRAUSER48651 ]

Daniel Lee [ dleeyh ]

Todd Stoffel (Inactive) made changes - 2023-04-05 04:35

Rank

Ranked higher

Daniel Lee (Inactive) made changes - 2023-04-05 18:17

Assignee	Daniel Lee [ dleeyh ]	Roman [ drrtuy ]
Status	In Testing [ 10301 ]	Stalled [ 10000 ]

Roman made changes - 2023-04-11 21:24

Link

This issue includes ~~MCOL-5472~~ [ ~~MCOL-5472~~ ]

Roman made changes - 2023-04-11 21:24

Affects Version/s

23.02.1 [ 28701 ]

Roman made changes - 2023-04-11 21:33

Link

This issue includes MCOL-5473 [ MCOL-5473 ]

Roman made changes - 2023-04-11 21:33

Link

This issue relates to MCOL-4593 [ MCOL-4593 ]

Roman made changes - 2023-04-11 23:34

Link

This issue includes MCOL-5474 [ MCOL-5474 ]

Roman made changes - 2023-04-11 23:34

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Todd Stoffel (Inactive) made changes - 2023-04-13 16:48

Rank

Ranked higher

alexey vorovich (Inactive) made changes - 2023-04-14 14:09

Fix Version/s		23.02 [ 28209 ]
Fix Version/s	23.02.2 [ 28713 ]

Allen Herrera made changes - 2023-06-28 18:38

Fix Version/s		23.08 [ 28540 ]
Fix Version/s	23.02 [ 28209 ]

alexey vorovich (Inactive) made changes - 2023-07-26 16:35

Labels

mcs_cs_spendhq

mcs_cs_spendhq rm_perf

alexey vorovich (Inactive) made changes - 2023-07-26 16:36

Sprint

2023-8 [ 728 ]

Todd Stoffel (Inactive) made changes - 2023-07-31 17:08

Rank

Ranked higher

Allen Herrera made changes - 2023-08-02 18:52

Priority

Blocker [ 1 ]

Critical [ 2 ]

Todd Stoffel (Inactive) made changes - 2023-08-25 22:55

Sprint

2023-8 [ 728 ]

2023-8, 2023-9 [ 728, 733 ]

Todd Stoffel (Inactive) made changes - 2023-08-25 22:55

Sprint

2023-8, 2023-9 [ 728, 733 ]

2023-8, 2023-10 [ 728, 734 ]

Todd Stoffel (Inactive) made changes - 2023-09-13 19:50

Sprint

2023-8, 2023-10 [ 728, 734 ]

2023-8, 2023-10, 2023-11 [ 728, 734, 737 ]

Allen Herrera made changes - 2023-10-30 21:00

Attachment

Columnstore-CTE-Test-Results.zip [ 72385 ]

Roman made changes - 2023-10-31 23:09

Fix Version/s		23.10.1 [ 29105 ]
Fix Version/s	23.10 [ 28540 ]

Roman made changes - 2023-11-01 17:09

Link

This issue includes ~~MCOL-5601~~ [ ~~MCOL-5601~~ ]

Roman made changes - 2023-11-01 17:24

Attachment		CTE3-3-patches.png [ 72405 ]
Attachment		CTE3-3-patches_2.png [ 72406 ]
Attachment		CTE2-3-patches.png [ 72407 ]
Attachment		CTE1-3-patches.png [ 72408 ]
Attachment		CTE3-23_10_0.png [ 72409 ]
Attachment		CTE2-23_10_0.png [ 72410 ]
Attachment		CTE1-23_10_0.png [ 72411 ]

Roman added a comment - 2023-11-01 17:25

Added bunch of screens with sysbench results to compare 23.10.0 and the build that has 3 patches out of 4.
CTE3 didn't get any better that means there was no mutex contention in the first place.

Roman added a comment - 2023-11-01 17:25 Added bunch of screens with sysbench results to compare 23.10.0 and the build that has 3 patches out of 4. CTE3 didn't get any better that means there was no mutex contention in the first place.

Julien Fritsch made changes - 2023-11-17 15:33

Labels

mcs_cs_spendhq rm_perf

rm_perf

Leonid Fedorov made changes - 2023-12-18 12:38

Fix Version/s		23.10 [ 28540 ]
Fix Version/s	23.10.1 [ 29105 ]

Julien Fritsch made changes - 2023-12-20 07:42

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Leonid Fedorov made changes - 2023-12-21 15:15

Sprint

2023-8, 2023-10, 2023-11 [ 728, 734, 737 ]

2023-8, 2023-10, 2023-11, 2023-13 [ 728, 734, 737, 748 ]

Julien Fritsch made changes - 2024-03-19 12:43

Sprint

2023-8, 2023-10, 2023-11, 2023-12 [ 728, 734, 737, 748 ]

2023-8, 2023-10, 2023-11, 2023-12, 2023-13 [ 728, 734, 737, 748, 755 ]

Jira Automation (IT) made changes - 2024-07-04 12:38

Zendesk Related Tickets

173338

Julien Fritsch made changes - 2024-07-31 13:30

Sprint

2023-8, 2023-10, 2023-11, 2023-12, 2024-1 [ 728, 734, 737, 748, 755 ]

2023-8, 2023-10, 2023-11, 2023-12, 2024-1, 2024-2 [ 728, 734, 737, 748, 755, 764 ]

Julien Fritsch made changes - 2025-02-03 15:34

Sprint

2023-8, 2023-10, 2023-11, 2023-12, 2024-1, 2024-2 [ 728, 734, 737, 748, 755, 764 ]

2023-8, 2023-10, 2023-11, 2023-12, 2024-1, 2024-2, 2024-3 [ 728, 734, 737, 748, 755, 764, 784 ]

Allen Herrera made changes - 2025-02-25 12:37

Sprint

2023-8, 2023-10, 2023-11, 2023-12, 2024-1, 2024-2, 2025-1 [ 728, 734, 737, 748, 755, 764, 784 ]

2023-8, 2023-10, 2023-11, 2023-12, 2024-1, 2024-2 [ 728, 734, 737, 748, 755, 764 ]

People

Assignee:: Roman

Reporter:: alexey vorovich (Inactive)

Votes:: 1 Vote for this issue

Watchers:: 9 Start watching this issue

Dates

Created:: 2023-03-21 15:48

Updated:: 2025-02-25 12:37

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB ColumnStore

Details

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration