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
              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.