Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-36285

Storage Engine for Information Schema (SHOW views)

    XMLWordPrintable

Details

    Description

      Information Schema tables, despite tablating data in storage engines (typically MEMORY). still fills its views with the entire data, field by field.
      For example, the code behind SELECT ... FROM information_schema.SLAVE_STATUS calls store_* functions sixty times whether it's SELECT * or SELECT Connection_name.

      Leveraging the column-filtering (and maybe even caching) capabilities of a storage engine or two, be it MEMORY or PERFORMANCE_SCHEMA, could improve performance.

      Attachments

        Activity

          People

            Unassigned Unassigned
            ParadoxV5 Jimmy Hú
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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