Information Schema ALL_PLUGINS Table
You are viewing an old version of this article. View
the current version here.
MariaDB starting with 10.0.2
The ALL_PLUGINS table was introduced in MariaDB 10.0.2
Description
The Information Schema ALL_PLUGINS table contains information about server plugins, whether installed or not.
It contains the following columns:
| Column | Description |
|---|---|
| PLUGIN_NAME | Name of the plugin. |
| PLUGIN_VERSION | Version from the plugin's general type descriptor. |
| PLUGIN_STATUS | Plugin status, one of ACTIVE, INACTIVE, DISABLED, DELETED or NOT INSTALLED. |
| PLUGIN_TYPE | Plugin type; STORAGE ENGINE, INFORMATION_SCHEMA, AUTHENTICATION, REPLICATION, DAEMON or AUDIT. |
| PLUGIN_TYPE_VERSION | Version from the plugin's type-specific descriptor. |
| PLUGIN_LIBRARY | Plugin's shared object file name, located in the directory specified by the plugin_dir system variable, and used by the INSTALL PLUGIN and UNINSTALL PLUGIN statements. NULL if the plugin is complied in and cannot be uninstalled. |
| PLUGIN_LIBRARY_VERSION | Version from the plugin's API interface. |
| PLUGIN_AUTHOR | Author of the plugin. |
| PLUGIN_DESCRIPTION | Description. |
| PLUGIN_LICENSE | Plugin's licence. |
| LOAD_OPTION | How the plugin was loaded; one of OFF, ON, FORCE or FORCE_PLUS_PERMANENT. See Installing Plugins. |
| PLUGIN_MATURITY | Plugin's maturity level; one of Unknown, Experimental, Alpha, Beta,'Gamma, and Stable. |
| PLUGIN_AUTH_VERSION | Plugin's version as determined by the plugin author. An example would be '0.99 beta 1'. |
It provides a superset of the information shown by the SHOW PLUGINS SONAME statement, as well as the INFORMATION_SCHEMA.PLUGINS table. For specific information about storage engines (a particular type of plugin), see the Information Schema ENGINES table and the SHOW ENGINES statement.
The table is not a standard Information Schema table, and is a MariaDB extension.
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
