Rechercher dans le manuel MySQL
5.5.1 Installing and Uninstalling Components
Server components must be loaded into the server before they can be used. MySQL supports component loading at runtime.
The INSTALL COMPONENT
and
UNINSTALL COMPONENT
SQL statements
enable component loading and unloading. For example:
- INSTALL COMPONENT 'file://component_validate_password';
- UNINSTALL COMPONENT 'file://component_validate_password';
A loader service handles component loading and unloading, and also
lists loaded components in the component
table
of the mysql
system database that serves as a
registry.
The SQL statements for component manipulation affect server
operation and the mysql.component
system table
as follows:
INSTALL COMPONENT
loads components into the server. The components become active immediately. The loader service also registers loaded components in themysql.component
system table. For subsequent server restarts, the loader service loads any components listed inmysql.component
during the startup sequence. This occurs even if the server is started with the--skip-grant-tables
option.UNINSTALL COMPONENT
deactivates components and unloads them from the server. The loader service also unregisters the components from themysql.component
system table so that they are no longer loaded during the startup sequence for subsequent server restarts.
Compared to the corresponding INSTALL
PLUGIN
statement for server plugins, the
INSTALL COMPONENT
statement for
components offers the significant advantage that it is not
necessary to know any platform-specific file name suffix for
naming the component. This means that a given
INSTALL COMPONENT
statement can be
executed uniformly across platforms.
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-component-loading.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.