本节描述有关密匙环使用的信息来源。

要查看是否加载了密匙环插件，请检查INFORMATION_SCHEMA。插件表或使用显示插件声明(见获取服务器插件信息)．例如:

mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA。插件的PLUGIN_NAME为'keyring%';+--------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS  | +--------------+---------------+ | keyring_file |活跃  | +--------------+---------------+

要查看存在哪些键，请检查Performance Schemakeyring_keys表:

SELECT * FROM performance_schema.keyring_keys;+-----------------------------+--------------+----------------+ | KEY_ID | KEY_OWNER | BACKEND_KEY_ID  | +-----------------------------+--------------+----------------+ | audit_log - 20210322 - t130749 - 1 | | | | MyKey | me@localhost | | | YourKey | me@localhost  | | +-----------------------------+--------------+----------------+

要查看是否加载了密匙环组件，请检查Performance Schemakeyring_component_status表格例如:

SELECT * FROM performance_schema.keyring_component_status;+---------------------+-------------------------------------------------+ | STATUS_KEY | STATUS_VALUE  | +---------------------+-------------------------------------------------+ | 甲骨文公司作者Component_name | component_keyring_file | | | | | |许可证GPL | | Implementation_name | component_keyring_file | |版本| 1.0 | | Component_status活动| | | Data_file | /usr/local/mysql/keyring/component_keyring_file | | Read_only | |+---------------------+-------------------------------------------------+

一个Component_status的价值活跃的指示组件初始化成功。如果加载了组件但初始化失败，则该值为禁用．