Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-5683

I_S.INNODB_TABLESPACES_ENCRYPTION isn't documented

    Details

    • Type: Bug
    • Status: Open
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 5.7.x, 8.0.x
    • Fix Version/s: None
    • Component/s: Documentation
    • Labels:

      Description

      There is no documentation in the Data at rest encryption docs about the I_S.INNODB_TABLESPACES_ENCRYPTION table.

      mysql> desc INNODB_TABLESPACES_ENCRYPTION;
      +------------------------------+---------------------+------+-----+---------+-------+
      | Field                        | Type                | Null | Key | Default | Extra |
      +------------------------------+---------------------+------+-----+---------+-------+
      | SPACE                        | int(11) unsigned    | NO   |     |         |       |
      | NAME                         | varchar(655)        | YES  |     |         |       |
      | ENCRYPTION_SCHEME            | int(11) unsigned    | NO   |     |         |       |
      | KEYSERVER_REQUESTS           | int(11) unsigned    | NO   |     |         |       |
      | MIN_KEY_VERSION              | int(11) unsigned    | NO   |     |         |       |
      | CURRENT_KEY_VERSION          | int(11) unsigned    | NO   |     |         |       |
      | KEY_ROTATION_PAGE_NUMBER     | bigint(21) unsigned | YES  |     |         |       |
      | KEY_ROTATION_MAX_PAGE_NUMBER | bigint(21) unsigned | YES  |     |         |       |
      | CURRENT_KEY_ID               | int(11) unsigned    | NO   |     |         |       |
      | ROTATING_OR_FLUSHING         | int(1) unsigned     | NO   |     |         |       |
      +------------------------------+---------------------+------+-----+---------+-------+
      

      

      Information can be found in the design docs and/or MariaDB KB

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                patrick.birch Patrick Birch
                Reporter:
                hrvoje.matijakovic Hrvoje Matijakovic
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 5 hours, 30 minutes
                  5h 30m