[MCOL-1862] Look into raising utilization during test001 Created: 2018-11-06  Updated: 2022-11-05  Resolved: 2022-11-05

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

Type: Task Priority: Minor
Reporter: Patrick LeBlanc (Inactive) Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: None


 Description   

Running test001, I noticed that barely anything was happening on either of the 2 nodes on this test system. My laptop fan isn't even running, and it always runs.

My initial guess from watching top is that there's a lot of chatter involving the controllernode. Since test001 is made up of mostly small queries, my guess is that there's a lot of back-and-forth getting session #s, getting unique #s, & the other non-versioning functionality that went into controllernode eventually, which is required to init a joblist.

We should look into why we have such low utilization when there is a constant stream of queries being run, and then make another ticket for proposed fixes. One possibility mentioned in Rome is that we're opening & closing connections too much. Maybe make the connection a singleton or a pool in the DBRM class. Maybe a singleton that becomes a pool when there is contention. Or magic. Magic always works right?



 Comments   
Comment by Todd Stoffel (Inactive) [ 2022-11-05 ]

Item is out of date. Closing due to inactivity. If you feel this was done in error please open a new ticket.

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