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

enabling temp-tablespace encryption doesn't mark innodb_temporary tablespace encryption flag

    XMLWordPrintable

    Details

      Description

      • Start server with innodb_temp_tablespace_encrypt=1 this will enable temporary tablespace encrpytion.
      • Check if the innodb_temporary (ibtmp1) that is used to cache temporary tablespace is encrypted.
      • From the output below encryption flag for innodb_temporary is not marked = Y.

      mysql> select @@innodb_temp_tablespace_encrypt;
      ----------------------------------

      @@innodb_temp_tablespace_encrypt

      ----------------------------------

      1

      ----------------------------------
      1 row in set (0.00 sec)

       

      mysql> select * from INNODB_TABLESPACES;
      --------------------------------------------------------------------------------------------------------------------------------------------------------------------+

      SPACE NAME FLAG ROW_FORMAT PAGE_SIZE ZIP_PAGE_SIZE SPACE_TYPE FS_BLOCK_SIZE FILE_SIZE ALLOCATED_SIZE SERVER_VERSION SPACE_VERSION ENCRYPTION STATE

      --------------------------------------------------------------------------------------------------------------------------------------------------------------------+

      4294967294 mysql 18432 Any 16384 0 General 4096 25165824 25165824 8.0.15 1 N normal
      4294967293 innodb_temporary 4096 Compact or Redundant 16384 0 System 0 0 0 8.0.15 1 N normal
      4294967279 innodb_undo_001 0 Undo 16384 0 Undo 0 0 0 8.0.15 1 N active
      4294967278 innodb_undo_002 0 Undo 16384 0 Undo 0 0 0 8.0.15 1 N active
      1 sys/sys_config 16417 Dynamic 16384 0 Single 4096 114688 81920 8.0.15 1 N normal

      --------------------------------------------------------------------------------------------------------------------------------------------------------------------+

       

       

        Attachments

          Activity

            People

            Assignee:
            satya.bodapati Satya Bodapati
            Reporter:
            krunal.bauskar Krunal Bauskar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

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

                  Smart Checklist