Documentation Home
MySQL 9.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.0Mb
PDF (A4) - 40.1Mb
Man Pages (TGZ) - 259.0Kb
Man Pages (Zip) - 366.2Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb


MySQL 9.0 Reference Manual  / ...  / INFORMATION_SCHEMA Tables  / INFORMATION_SCHEMA General Tables  /  The INFORMATION_SCHEMA PLUGINS Table

28.3.22 The INFORMATION_SCHEMA PLUGINS Table

ThePLUGINS table provides information about server plugins.

ThePLUGINS table has these columns:

  • PLUGIN_NAME

    The name used to refer to the plugin in statements such asINSTALL PLUGIN andUNINSTALL PLUGIN.

  • PLUGIN_VERSION

    The version from the plugin's general type descriptor.

  • PLUGIN_STATUS

    The plugin status, one ofACTIVE,INACTIVE,DISABLED,DELETING, orDELETED.

  • PLUGIN_TYPE

    The type of plugin, such asSTORAGE ENGINE,INFORMATION_SCHEMA, orAUTHENTICATION.

  • PLUGIN_TYPE_VERSION

    The version from the plugin's type-specific descriptor.

  • PLUGIN_LIBRARY

    The name of the plugin shared library file. This is the name used to refer to the plugin file in statements such asINSTALL PLUGIN andUNINSTALL PLUGIN. This file is located in the directory named by theplugin_dir system variable. If the library name isNULL, the plugin is compiled in and cannot be uninstalled withUNINSTALL PLUGIN.

  • PLUGIN_LIBRARY_VERSION

    The plugin API interface version.

  • PLUGIN_AUTHOR

    The plugin author.

  • PLUGIN_DESCRIPTION

    A short description of the plugin.

  • PLUGIN_LICENSE

    How the plugin is licensed (for example,GPL).

  • LOAD_OPTION

    How the plugin was loaded. The value isOFF,ON,FORCE, orFORCE_PLUS_PERMANENT. SeeSection 7.6.1, “Installing and Uninstalling Plugins”.

Notes

  • PLUGINS is a nonstandardINFORMATION_SCHEMA table.

  • For plugins installed withINSTALL PLUGIN, thePLUGIN_NAME andPLUGIN_LIBRARY values are also registered in themysql.plugin table.

  • For information about plugin data structures that form the basis of the information in thePLUGINS table, seeThe MySQL Plugin API.

Plugin information is also available from theSHOW PLUGINS statement. SeeSection 15.7.7.26, “SHOW PLUGINS Statement”. These statements are equivalent:

SELECT  PLUGIN_NAME, PLUGIN_STATUS, PLUGIN_TYPE,  PLUGIN_LIBRARY, PLUGIN_LICENSEFROM INFORMATION_SCHEMA.PLUGINS;SHOW PLUGINS;