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

Document special names used in information_schema's INNODB_TABLESPACES_ENCRYPTION

    XMLWordPrintable

Details

    Description

      The "Name" field in information_schema's INNODB_TABLESPACES_ENCRYPTION table supposedly refers to a path name. However, there seems to be at least one "special" value used in this field--"innodb_system":

      MariaDB [(none)]> SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE NAME='innodb_system'\G
      *************************** 1. row ***************************
                             SPACE: 0
                              NAME: innodb_system
                 ENCRYPTION_SCHEME: 1
                KEYSERVER_REQUESTS: 1
                   MIN_KEY_VERSION: 1
               CURRENT_KEY_VERSION: 1
          KEY_ROTATION_PAGE_NUMBER: NULL
      KEY_ROTATION_MAX_PAGE_NUMBER: NULL
                    CURRENT_KEY_ID: 1
              ROTATING_OR_FLUSHING: 0
      1 row in set (0.00 sec)
      

      I assume that this special value refers to the system tablespace, as defined by innodb_data_file_path (usually ibdata1). However, if it is, it does not appear to be documented:

      https://mariadb.com/kb/en/library/information-schema-innodb_tablespaces_encryption-table/

      If any other special values are also used in this table, then those should probably also be documented.

      Attachments

        Issue Links

          Activity

            People

              russell.dyer Russell Dyer (Inactive)
              GeoffMontee Geoff Montee (Inactive)
              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.