[MDEV-17324] Make information_schema table that shows which Aria tables are encrypted Created: 2018-09-28 Updated: 2023-11-30 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Encryption, Information Schema, Storage Engine - Aria |
| Fix Version/s: | None |
| Type: | New Feature | Priority: | Major |
| Reporter: | Geoff Montee (Inactive) | Assignee: | Ralf Gebhardt |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | beginner-friendly | ||
| Issue Links: |
|
||||||||||||||||||||||||||||
| Description |
|
You can query information_schema.INNODB_TABLESPACES_ENCRYPTION to determine which InnoDB tables are encrypted: https://mariadb.com/kb/en/library/innodb-encryption-overview/#finding-encrypted-tables https://mariadb.com/kb/en/library/information-schema-innodb_tablespaces_encryption-table/ Aria tables can also be encrypted if aria_encrypt_tables is enabled: https://mariadb.com/kb/en/library/aria-system-variables/#aria_encrypt_tables However, there does not seem to be any information_schema table that shows which Aria tables are encrypted. Wouldn't it make sense to make this information available? https://mariadb.com/kb/en/library/information-schema-tables/ Currently, you have to use the very user-unfriendly method shown here: |