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

          Ascending order - Click to sort in descending order
          marko Marko Mäkelä created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Fix Version/s 10.2 [ 14601 ]
          marko Marko Mäkelä made changes -
          Affects Version/s 10.3 [ 22126 ]
          marko Marko Mäkelä made changes -
          Fix Version/s 10.3 [ 22126 ]
          marko Marko Mäkelä made changes -
          Status Open [ 1 ] Confirmed [ 10101 ]
          marko Marko Mäkelä made changes -
          Sprint 10.3.6 [ 237 ]
          marko Marko Mäkelä made changes -
          Status Confirmed [ 10101 ] In Progress [ 3 ]
          marko Marko Mäkelä added a comment -

          bb-10.2-marko

          marko Marko Mäkelä added a comment - bb-10.2-marko
          marko Marko Mäkelä made changes -
          Assignee Marko Mäkelä [ marko ] Thirunarayanan B [ thiru ]
          Status In Progress [ 3 ] In Review [ 10002 ]
          thiru Thirunarayanan Balathandayuthapani added a comment -

          Patch approved. OK to push

          thiru Thirunarayanan Balathandayuthapani added a comment - Patch approved. OK to push
          thiru Thirunarayanan Balathandayuthapani made changes -
          Assignee Thirunarayanan B [ thiru ] Marko Mäkelä [ marko ]
          marko Marko Mäkelä made changes -
          issue.field.resolutiondate 2018-03-22 16:13:13.0 2018-03-22 16:13:13.183
          marko Marko Mäkelä made changes -
          Fix Version/s 10.2.14 [ 22911 ]
          Fix Version/s 10.3.6 [ 23003 ]
          Fix Version/s 10.2 [ 14601 ]
          Fix Version/s 10.3 [ 22126 ]
          Resolution Fixed [ 1 ]
          Status In Review [ 10002 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 79504 ] MariaDB v4 [ 151658 ]

          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.