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

I_S.INNODB_TABLESPACES_ENCRYPTION isn't documented

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: In Review
    • 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

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            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

                  Smart Checklist