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

Avoid accessing SYS_TABLESPACES unnecessarily

Details

    • 10.3.6-1

    Description

      The view information_schema.innodb_tablespaces_encryption is unnecessarily retrieving the data from the SYS_TABLESPACES table instead of directly fetching it from the fil_system cache. InnoDB always loads all tablespace metadata into memory at startup and never evicts it while the tablespace exists.
      Similar unnecessary access could exist elsewhere in InnoDB. We should replace all those. Only the view INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES is intentionally retrieving the data directly from the table.

      Attachments

        Activity

          Transition Time In Source Status Execution Times
          Marko Mäkelä made transition -
          Open Confirmed
          300d 20h 58m 1
          Marko Mäkelä made transition -
          Confirmed In Progress
          111d 56m 1
          Marko Mäkelä made transition -
          In Progress In Review
          1h 33m 1
          Marko Mäkelä made transition -
          In Review Closed
          6h 38m 1

          People

            marko Marko Mäkelä
            marko Marko Mäkelä
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.