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

innodb_tablespace does not show correct encryption status for innodb_temporary

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Won't Fix
    • Affects Version/s: 8.0.16-7
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      mysql> select * from information_schema.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 24117248 24121344 8.0.16 1 N normal
      0 innodb_system 18432 Any 16384 0 System 0 0 0 8.0.16 1 N normal
      4294967293 innodb_temporary 4096 Any 16384 0 System 0 0 0 8.0.16 1 N normal
      4294967279 innodb_undo_001 0 Undo 16384 0 Undo 4096 10485760 10485760 8.0.16 1 N active
      4294967278 innodb_undo_002 0 Undo 16384 0 Undo 4096 10485760 10485760 8.0.16 1 N active
      1 sys/sys_config 16417 Dynamic 16384 0 Single 4096 114688 81920 8.0.16 1 N normal
      2 mohit/t3 16417 Dynamic 16384 0 Single 4096 114688 81920 8.0.16 1 N normal

      ----------------------------------------------------------------------------------------------------------------------------------------------------------+
      7 rows in set (0.00 sec)

      mysql> set global innodb_temp_tablespace_encrypt=ON;
      Query OK, 0 rows affected (0.00 sec)

      mysql> select * from information_schema.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 24117248 24121344 8.0.16 1 N normal
      0 innodb_system 18432 Any 16384 0 System 0 0 0 8.0.16 1 N normal
      4294967293 innodb_temporary 4096 Any 16384 0 System 0 0 0 8.0.16 1 Y normal
      4294967279 innodb_undo_001 0 Undo 16384 0 Undo 4096 10485760 10485760 8.0.16 1 N active
      4294967278 innodb_undo_002 0 Undo 16384 0 Undo 4096 10485760 10485760 8.0.16 1 N active
      1 sys/sys_config 16417 Dynamic 16384 0 Single 4096 114688 81920 8.0.16 1 N normal
      2 mohit/t3 16417 Dynamic 16384 0 Single 4096 114688 81920 8.0.16 1 N normal

      ----------------------------------------------------------------------------------------------------------------------------------------------------------+
      7 rows in set (0.00 sec)

      mysql> set global innodb_temp_tablespace_encrypt=OFF;
      Query OK, 0 rows affected (0.00 sec)

      mysql> select * from information_schema.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 24117248 24121344 8.0.16 1 N normal
      0 innodb_system 18432 Any 16384 0 System 0 0 0 8.0.16 1 N normal
      4294967293 innodb_temporary 4096 Any 16384 0 System 0 0 0 8.0.16 1 Y normal
      4294967279 innodb_undo_001 0 Undo 16384 0 Undo 4096 10485760 10485760 8.0.16 1 N active
      4294967278 innodb_undo_002 0 Undo 16384 0 Undo 4096 10485760 10485760 8.0.16 1 N active
      1 sys/sys_config 16417 Dynamic 16384 0 Single 4096 114688 81920 8.0.16 1 N normal
      2 mohit/t3 16417 Dynamic 16384 0 Single 4096 114688 81920 8.0.16 1 N normal

      ----------------------------------------------------------------------------------------------------------------------------------------------------------+
      7 rows in set (0.00 sec)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              satya.bodapati Satya Bodapati
              Reporter:
              mohit.joshi Mohit Joshi
              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 - 30 minutes
                  30m

                    Smart Checklist