Documentation Home
MySQL Performance Schema
Related Documentation Download this Excerpt
PDF (US Ltr) - 1.1Mb
PDF (A4) - 1.1Mb
HTML Download (TGZ) - 170.3Kb
HTML Download (Zip) - 188.7Kb


10.18.2 The keyring_keys table

MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive information for later retrieval. See The MySQL Keyring.

As of MySQL 8.0.16, the keyring_keys table exposes metadata for keys in the keyring. Key metadata includes key IDs, key owners, and backend key IDs. The keyring_keys table does not expose any sensitive keyring data such as key contents.

The keyring_keys table has these columns:

  • KEY_ID

    The key identifier.

  • KEY_OWNER

    The owner of the key.

  • BACKEND_KEY_ID

    The ID used for the key by the keyring backend.

The keyring_keys table has no indexes.

TRUNCATE TABLE is not permitted for the keyring_keys table.