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

              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: