Documentation Home
MySQL 8.3 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 294.0Kb
Man Pages (Zip) - 409.0Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb
Excerpts from this Manual

MySQL 8.3 Reference Manual  /  ...  /  Obtaining Component Information

7.5.2 获取组件信息

系统表 mysql.component 包含当前加载的组件信息,并显示了使用 INSTALL COMPONENT 注册的组件。从表中选择将显示已安装的组件。例如:

mysql> SELECT * FROM mysql.component;
+--------------+--------------------+------------------------------------+
| component_id | component_group_id | component_urn                      |
+--------------+--------------------+------------------------------------+
|            1 |                  1 | file://component_validate_password |
|            2 |                  2 | file://component_log_sink_json     |
+--------------+--------------------+------------------------------------+

component_idcomponent_group_id 值仅供内部使用。component_urn 是在 INSTALL COMPONENTUNINSTALL COMPONENT 语句中加载和卸载组件时使用的URN。