Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 32.9Mb
PDF (A4) - 32.9Mb
PDF (RPM) - 30.9Mb
HTML Download (TGZ) - 7.8Mb
HTML Download (Zip) - 7.9Mb
HTML Download (RPM) - 6.7Mb
Man Pages (TGZ) - 143.5Kb
Man Pages (Zip) - 203.6Kb
Info (Gzip) - 3.0Mb
Info (Zip) - 3.0Mb


MySQL 8.0 Reference Manual  /  MySQL Server Administration  /  MySQL Server Components

Pre-General Availability Draft: 2017-07-21

5.5 MySQL Server Components

MySQL Server includes a component-based infrastructure for improving server extensibility:

  • 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 components.) Components interact with each other only through the services they provide.

  • Components are installed and uninstalled using the INSTALL COMPONENT and UNINSTALL COMPONENT SQL statements.

  • A loader service handles component installation and uninstallation, and also lists installed components in the mysql.component system table, which serves as a registry.

The SQL statements for component manipulation affect server operation and the mysql.component system table as follows:

  • INSTALL COMPONENT installs components into the server. The components become active immediately. The loader service also registers installed components in the mysql.component table. For subsequent server restarts, any components listed in mysql.component are installed by the loader service during the startup sequence. This occurs even if the server is started with the --skip-grant-tables option.

  • UNINSTALL COMPONENT deactivates components and uninstalls them from the server. The loader service also unregisters the components from the mysql.component table so that they are no longer installed during the startup sequence for subsequent server restarts.

For information about the internal implementation of components, see http://dev.mysql.com/doc/dev/mysql-server/latest/PAGE_EXTENDING.html. For example, if you intend to write your own components, this information is important for understanding how components work.


User Comments
Sign Up Login You must be logged in to post a comment.