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

Look into raising utilization during test001

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Do
    • None
    • Icebox
    • N/A
    • 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?

      Attachments

        Activity

          People

            Unassigned Unassigned
            pleblanc Patrick LeBlanc (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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