<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-plugins-table">
      </a>
      28.3.22 The INFORMATION_SCHEMA PLUGINS Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045079229232">
  </a>
  <p>
   The
   <a class="link" href="information-schema-plugins-table.html" title="28.3.22 The INFORMATION_SCHEMA PLUGINS Table">
    <code class="literal">
     PLUGINS
    </code>
   </a>
   table provides
      information about server plugins.
  </p>
  <p>
   The
   <a class="link" href="information-schema-plugins-table.html" title="28.3.22 The INFORMATION_SCHEMA PLUGINS Table">
    <code class="literal">
     PLUGINS
    </code>
   </a>
   table has these columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       PLUGIN_NAME
      </code>
     </p>
     <p>
      The name used to refer to the plugin in statements such as
      <a class="link" href="install-plugin.html" title="15.7.4.4 INSTALL PLUGIN Statement">
       <code class="literal">
        INSTALL PLUGIN
       </code>
      </a>
      and
      <a class="link" href="uninstall-plugin.html" title="15.7.4.6 UNINSTALL PLUGIN Statement">
       <code class="literal">
        UNINSTALL PLUGIN
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       PLUGIN_VERSION
      </code>
     </p>
     <p>
      The version from the plugin's general type descriptor.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       PLUGIN_STATUS
      </code>
     </p>
     <p>
      The plugin status, one of
      <code class="literal">
       ACTIVE
      </code>
      ,
      <code class="literal">
       INACTIVE
      </code>
      ,
      <code class="literal">
       DISABLED
      </code>
      ,
      <code class="literal">
       DELETING
      </code>
      , or
      <code class="literal">
       DELETED
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       PLUGIN_TYPE
      </code>
     </p>
     <p>
      The type of plugin, such as
      <code class="literal">
       STORAGE ENGINE
      </code>
      ,
      <code class="literal">
       INFORMATION_SCHEMA
      </code>
      , or
      <code class="literal">
       AUTHENTICATION
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       PLUGIN_TYPE_VERSION
      </code>
     </p>
     <p>
      The version from the plugin's type-specific descriptor.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       PLUGIN_LIBRARY
      </code>
     </p>
     <p>
      The name of the plugin shared library file. This is the name
          used to refer to the plugin file in statements such as
      <a class="link" href="install-plugin.html" title="15.7.4.4 INSTALL PLUGIN Statement">
       <code class="literal">
        INSTALL PLUGIN
       </code>
      </a>
      and
      <a class="link" href="uninstall-plugin.html" title="15.7.4.6 UNINSTALL PLUGIN Statement">
       <code class="literal">
        UNINSTALL PLUGIN
       </code>
      </a>
      . This file is
          located in the directory named by the
      <a class="link" href="server-system-variables.html#sysvar_plugin_dir">
       <code class="literal">
        plugin_dir
       </code>
      </a>
      system variable.
          If the library name is
      <code class="literal">
       NULL
      </code>
      , the plugin is
          compiled in and cannot be uninstalled with
      <a class="link" href="uninstall-plugin.html" title="15.7.4.6 UNINSTALL PLUGIN Statement">
       <code class="literal">
        UNINSTALL PLUGIN
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       PLUGIN_LIBRARY_VERSION
      </code>
     </p>
     <p>
      The plugin API interface version.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       PLUGIN_AUTHOR
      </code>
     </p>
     <p>
      The plugin author.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       PLUGIN_DESCRIPTION
      </code>
     </p>
     <p>
      A short description of the plugin.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       PLUGIN_LICENSE
      </code>
     </p>
     <p>
      How the plugin is licensed (for example,
      <code class="literal">
       GPL
      </code>
      ).
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       LOAD_OPTION
      </code>
     </p>
     <p>
      How the plugin was loaded. The value is
      <code class="literal">
       OFF
      </code>
      ,
      <code class="literal">
       ON
      </code>
      ,
      <code class="literal">
       FORCE
      </code>
      , or
      <code class="literal">
       FORCE_PLUS_PERMANENT
      </code>
      . See
      <a class="xref" href="plugin-loading.html" title="7.6.1 Installing and Uninstalling Plugins">
       Section 7.6.1, “Installing and Uninstalling Plugins”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
  <h4>
   <a name="idm46045079184656">
   </a>
   Notes
  </h4>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="link" href="information-schema-plugins-table.html" title="28.3.22 The INFORMATION_SCHEMA PLUGINS Table">
       <code class="literal">
        PLUGINS
       </code>
      </a>
      is a nonstandard
      <code class="literal">
       INFORMATION_SCHEMA
      </code>
      table.
     </p>
    </li>
    <li class="listitem">
     <p>
      For plugins installed with
      <a class="link" href="install-plugin.html" title="15.7.4.4 INSTALL PLUGIN Statement">
       <code class="literal">
        INSTALL
          PLUGIN
       </code>
      </a>
      , the
      <code class="literal">
       PLUGIN_NAME
      </code>
      and
      <code class="literal">
       PLUGIN_LIBRARY
      </code>
      values are also registered
          in the
      <code class="literal">
       mysql.plugin
      </code>
      table.
     </p>
    </li>
    <li class="listitem">
     <p>
      For information about plugin data structures that form the
          basis of the information in the
      <a class="link" href="information-schema-plugins-table.html" title="28.3.22 The INFORMATION_SCHEMA PLUGINS Table">
       <code class="literal">
        PLUGINS
       </code>
      </a>
      table, see
      <a class="ulink" href="/doc/extending-mysql/8.4/en/plugin-api.html" target="_top">
       The MySQL Plugin API
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
  <p>
   Plugin information is also available from the
   <a class="link" href="show-plugins.html" title="15.7.7.27 SHOW PLUGINS Statement">
    <code class="literal">
     SHOW PLUGINS
    </code>
   </a>
   statement. See
   <a class="xref" href="show-plugins.html" title="15.7.7.27 SHOW PLUGINS Statement">
    Section 15.7.7.27, “SHOW PLUGINS Statement”
   </a>
   . These statements are equivalent:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa82308959"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token keyword">SELECT</span>
  PLUGIN_NAME<span class="token punctuation">,</span> PLUGIN_STATUS<span class="token punctuation">,</span> PLUGIN_TYPE<span class="token punctuation">,</span>
  PLUGIN_LIBRARY<span class="token punctuation">,</span> PLUGIN_LICENSE
<span class="token keyword">FROM</span> INFORMATION_SCHEMA<span class="token punctuation">.</span><span class="token keyword">PLUGINS</span><span class="token punctuation">;</span>

<span class="token keyword">SHOW</span> <span class="token keyword">PLUGINS</span><span class="token punctuation">;</span></code></pre>
  </div>
 </div>
 <br/>
</div>
