Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Fixed
-
8.0.x, Not 5.6.x, Not 5.7.x
-
None
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 |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------+
