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

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated: