Pre-General Availability Draft: 2017-05-29
This statement installs one or more server components, which
become active immediately. A component provides services that
are available to the server and other components. (With respect
to service use, the server is a component, equal to other
INSERT privilege for
mysql.component system table.
A loader service handles component installation and
uninstallation, and also lists installed components in the
mysql.component system table, which serves as
a registry. For subsequent server restarts, any components
mysql.component are installed by
the loader service during the startup sequence. This occurs even
if the server is started with the
If a component depends on services not present in the registry and you attempt to install the component without also installing the component or components that provide the services it depends on, an error occurs:
ERROR 3527 (HY000): Cannot satisfy dependency for service 'component1' required by component 'component2'.
To avoid this, either install all components in the same statement, or install the dependent component after installing any components it depends on.
If any error occurs, the statement fails and has no effect. For example, this happens if a component name is erroneous, a named component does not exist or is already installed, or component initialization fails.
Currently, component names are URNs that begin with
file:// and for which the following file name
value contains no directory names and is relative to the
directory named by the
plugin_dir system variable.
Component names do not include any platform-dependent file name
suffix such as
.dll. These details are subject to change
because component name interpretation is itself performed by a
service and the component infrastructure makes it possible to
replace the default service implementation with alternative
INSTALL COMPONENT 'file://component1', 'file://component2';
For additional information about components, see Section 6.5, “MySQL Server Components”.