The Ultimate Guide to High Availability with MariaDB

Information Schema INNODB_TABLESPACES_ENCRYPTION Table

You are viewing an old version of this article. View the current version here.
MariaDB starting with 10.1.3

Encryption of tables and tablespaces was added in MariaDB 10.1.3.

The Information Schema INNODB_TABLESPACES_ENCRYPTION table contains encryption information.

The PROCESS privilege is required to view the table.

It has the following columns:

ColumnDescriptionAdded
SPACEInnodb table space id number.
NAMEPath to the table space file, without the extension.
ENCRYPTION_SCHEMEKey derivation algorithm (currently only 1 is in use), or zero if not encrypted.
KEYSERVER_REQUESTSNumber of times InnoDB has had to request a key from the encryption plugin. The three most recent keys are cached internally.
MIN_KEY_VERSIONMinimum key version used to encrypt a page in the table space. Different pages may be encrypted with different key versions.
CURRENT_KEY_VERSIONKey version that will be used to encrypt pages.
KEY_ROTATION_PAGE_NUMBERPage that the key rotation thread is currently rotating, or NULL if key rotation is not enabled.
KEY_ROTATION_MAX_PAGE_NUMBERWhen a key rotation thread starts rotating a table space, the field contains its current size. NULL if key rotation is not enabled.
CURRENT_KEY_IDMariaDB 10.1.13

Example

SELECT * FROM information_schema.INNODB_TABLESPACES_ENCRYPTION 
WHERE NAME LIKE 'db_encrypt%';
+-------+----------------------------------------------+-------------------+--------------------+-----------------+---------------------+--------------------------+------------------------------+
| SPACE | NAME                                         | ENCRYPTION_SCHEME | KEYSERVER_REQUESTS | MIN_KEY_VERSION | CURRENT_KEY_VERSION | KEY_ROTATION_PAGE_NUMBER | KEY_ROTATION_MAX_PAGE_NUMBER |
+-------+----------------------------------------------+-------------------+--------------------+-----------------+---------------------+--------------------------+------------------------------+
|    18 | db_encrypt/t_encrypted_existing_key          |                 1 |                  1 |               1 |                   1 |                     NULL |                         NULL |
|    19 | db_encrypt/t_not_encrypted_existing_key      |                 1 |                  0 |               1 |                   1 |                     NULL |                         NULL |
|    20 | db_encrypt/t_not_encrypted_non_existing_key  |                 1 |                  0 |      4294967295 |          4294967295 |                     NULL |                         NULL |
|    21 | db_encrypt/t_default_encryption_existing_key |                 1 |                  1 |               1 |                   1 |                     NULL |                         NULL |
|    22 | db_encrypt/t_encrypted_default_key           |                 1 |                  1 |               1 |                   1 |                     NULL |                         NULL |
|    23 | db_encrypt/t_not_encrypted_default_key       |                 1 |                  0 |               1 |                   1 |                     NULL |                         NULL |
|    24 | db_encrypt/t_defaults                        |                 1 |                  1 |               1 |                   1 |                     NULL |                         NULL |
+-------+----------------------------------------------+-------------------+--------------------+-----------------+---------------------+--------------------------+------------------------------+
7 rows in set (0.00 sec)

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.