[MCOL-2145] user priority test showed unexpected performance behavior Created: 2019-02-07  Updated: 2021-01-15

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: 1.2.3
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Daniel Lee (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Build tested: 1.2.3-1 from buildbot

server commit:
61f32f2
engine commit:
46cc344

The mixed user test showed the following performance timing:
Mixed user types
----------------
HighUser = 9.080 sec @ priority 100
MediumUser = 9.352 sec @ priority 66
LowUser = 7.283 sec @ priority 33
NoPriUser = 3.402 sec @ priority 33

Few days ago, the same test return the following expected result:

Mixed user types
----------------
HighUser = 4.106 sec @ priority 100
MediumUser = 5.757 sec @ priority 66
LowUser = 9.107 sec @ priority 33
NoPriUser = 9.258 sec @ priority 33



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2019-02-08 ]

I don't think this is a bug. The way the priority system is designed this will occasionally happen. Especially if you have a lower core count. I would retest several times and if you are still having problems the check the query stats to make sure priority is being set correctly.

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