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

Document special names used in information_schema's INNODB_TABLESPACES_ENCRYPTION

    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

              • Assignee:
                russell.dyer Russell Dyer
                Reporter:
                GeoffMontee Geoff Montee
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: