mysql.component 系统表包含有关当前已加载组件的信息,并显示哪些组件已使用 INSTALL
COMPONENT 注册。从该表中选择可以显示已安装的组件。例如:The mysql.component system table contains
information about currently loaded components and shows which
components have been registered using INSTALL
COMPONENT. Selecting from the table shows which
components are installed. For example:
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_id 和 component_group_id 的值仅供内部使用。component_urn 是在 INSTALL COMPONENT 和 UNINSTALL COMPONENT 语句中用于加载和卸载组件的 URN。The component_id and
component_group_id values are for internal use.
The component_urn is the URN used in
INSTALL COMPONENT and
UNINSTALL COMPONENT statements to
load and unload the component.