Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17324

Make information_schema table that shows which Aria tables are encrypted

    XMLWordPrintable

    Details

      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:

      https://mariadb.com/kb/en/library/aria-encryption-overview/#determining-whether-a-table-is-encrypted

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              ralf.gebhardt@mariadb.com Ralf Gebhardt
              Reporter:
              GeoffMontee Geoff Montee
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated: