Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
Description
The "Name" field in information_schema's INNODB_TABLESPACES_ENCRYPTION table supposedly refers to a path name. However, there seems to be at least one "special" value used in this field--"innodb_system":
MariaDB [(none)]> SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE NAME='innodb_system'\G
|
*************************** 1. row ***************************
|
SPACE: 0
|
NAME: innodb_system
|
ENCRYPTION_SCHEME: 1
|
KEYSERVER_REQUESTS: 1
|
MIN_KEY_VERSION: 1
|
CURRENT_KEY_VERSION: 1
|
KEY_ROTATION_PAGE_NUMBER: NULL
|
KEY_ROTATION_MAX_PAGE_NUMBER: NULL
|
CURRENT_KEY_ID: 1
|
ROTATING_OR_FLUSHING: 0
|
1 row in set (0.00 sec)
|
I assume that this special value refers to the system tablespace, as defined by innodb_data_file_path (usually ibdata1). However, if it is, it does not appear to be documented:
https://mariadb.com/kb/en/library/information-schema-innodb_tablespaces_encryption-table/
If any other special values are also used in this table, then those should probably also be documented.
Attachments
Issue Links
- relates to
-
MDEV-14157 Improve documentation of data at rest encryption
- Closed