Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4593

Multiple concurrent queries with aggregates are bottlenecked, result in lack of user scalability

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Blocker
    • Resolution: Unresolved
    • Affects Version/s: 1.2.0
    • Fix Version/s: 6.3.1
    • Component/s: None
    • Labels:

      Description

      It has been proven by multiple experiments that Columnstore does not scale with increasing concurrency, when queries with aggregates are involved. Every additional query stream adds average latency to all other sessions regardless of the available resources and secret columnstore settings.

      Total CPU consumed by PrimProcs is likewise not linear (2 concurrent sessions spend more than 2x total CPU in PrimProc as compared to just one), indicating some sort of spin lock.

      The issue was escalated from a prospect (Quinstreet) who discovered it.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              drrtuy Roman
              Reporter:
              gdorman Gregory Dorman
              Votes:
              3 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration