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

Improve performance of system catalog

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • None
    • Icebox
    • N/A
    • None

    Description

      System Catalog columnRIDs is quite slow when there are many columns in an installation. When iterating over a table this takes a very long time to execute and populate. This matters for information_schema and mcsapi.

      Proposed changes:

      1. system catalog should not flush the entire cache on a single table change, just the table that changed
      2. tableinfo() call to columnRIDs should use cache
      3. for information_schema and mcsapi there should be a call that retrieves the entire catalog without the filter conditions instead of lots of loops that we do at the moment.
      4. mcsapi (in DBRM's doGetSystemCatalog) we should switch to FE mode:

      systemCatalogPtr->identity(execplan::CalpontSystemCatalog::FE);
      

      Attachments

        Issue Links

          Activity

            People

              toddstoffel Todd Stoffel (Inactive)
              LinuxJedi Andrew Hutchings (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.