The server can load plugins under the control of startup options.
For example, many storage engines can be built in pluggable form
and loaded when the server starts. In the following descriptions,
plugin_name stands for a plugin name
As of MySQL 5.1.36, options used to control plugin loading have a tristate format:
Do not enable the plugin.
Enable the plugin. If plugin initialization fails, start the
server anyway, but with the plugin disabled. Specifying the
without a value also enables the plugin.
Enable the plugin. If plugin initialization fails, do not start the server. In other words, force the server to run with the plugin or not at all.
FORCE are not case sensitive.
If a plugin is disabled, either explicitly with
OFF or implicitly because it was enabled with
ON but failed to initialize, aspects of server
operation that require the plugin will change. For example, if the
plugin implements a storage engine, existing tables for the
storage engine become inaccessible, and attempts to create new
tables for the storage engine result in tables that use the
default storage engine unless the
NO_ENGINE_SUBSTITUTION SQL mode
has been enabled to cause an error to occur instead.
ARCHIVE are built as pluggable storage
engines and that you want the server to load them at startup,
subject to these conditions: The server is allowed to run if
CSV initialization fails, but must require that
InnoDB initialization succeed.
ARCHIVE should be disabled. To accomplish that,
use these lines in an option file:
[mysqld] csv=ON innodb=FORCE archive=OFF
is also supported and is the same as
are also supported and are the same as
Before MySQL 5.1.36, plugin options are boolean options (see Section 184.108.40.206, “Program Option Modifiers”). That is, any of these options enable the plugin:
And these options disable the plugin:
If the plugin fails to initialize, the server runs with the plugin disabled.
If you upgrade to MySQL 5.1.36 or later from an older version and
previously used options of the form
equivalent options are now
respectively. You also have the choice of requiring plugins to
start successfully by using