<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="obtaining-plugin-information">
      </a>
      7.6.2 Obtaining Server Plugin Information
     </h3>
    </div>
   </div>
  </div>
  <p>
   There are several ways to determine which plugins are installed in
      the server:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      The Information Schema
      <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 contains a row for each loaded plugin. Any that have a
      <code class="literal">
       PLUGIN_LIBRARY
      </code>
      value of
      <code class="literal">
       NULL
      </code>
      are built in and cannot be unloaded.
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa47411071"><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 prompt">mysql&gt;</span> <span class="token keyword">TABLE</span> INFORMATION_SCHEMA<span class="token punctuation">.</span><span class="token keyword">PLUGINS</span>\G
<span class="token output"><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 1. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
           PLUGIN_NAME<span class="token punctuation">:</span> binlog
        PLUGIN_VERSION<span class="token punctuation">:</span> 1.0
         PLUGIN_STATUS<span class="token punctuation">:</span> ACTIVE
           PLUGIN_TYPE<span class="token punctuation">:</span> STORAGE ENGINE
   PLUGIN_TYPE_VERSION<span class="token punctuation">:</span> 80100.0
        PLUGIN_LIBRARY<span class="token punctuation">:</span> NULL
PLUGIN_LIBRARY_VERSION<span class="token punctuation">:</span> NULL
         PLUGIN_AUTHOR<span class="token punctuation">:</span> Oracle Corporation
    PLUGIN_DESCRIPTION<span class="token punctuation">:</span> This is a pseudo storage engine to represent the binlog in a transaction
        PLUGIN_LICENSE<span class="token punctuation">:</span> GPL
           LOAD_OPTION<span class="token punctuation">:</span> FORCE
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 2. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
           PLUGIN_NAME<span class="token punctuation">:</span> mysql_native_password
        PLUGIN_VERSION<span class="token punctuation">:</span> 1.1
         PLUGIN_STATUS<span class="token punctuation">:</span> ACTIVE
           PLUGIN_TYPE<span class="token punctuation">:</span> AUTHENTICATION
   PLUGIN_TYPE_VERSION<span class="token punctuation">:</span> 2.1
        PLUGIN_LIBRARY<span class="token punctuation">:</span> NULL
PLUGIN_LIBRARY_VERSION<span class="token punctuation">:</span> NULL
         PLUGIN_AUTHOR<span class="token punctuation">:</span> Oracle Corporation
    PLUGIN_DESCRIPTION<span class="token punctuation">:</span> Native MySQL authentication
        PLUGIN_LICENSE<span class="token punctuation">:</span> GPL
           LOAD_OPTION<span class="token punctuation">:</span> FORCE
...</span></code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      The
      <a class="link" href="show-plugins.html" title="15.7.7.27 SHOW PLUGINS Statement">
       <code class="literal">
        SHOW PLUGINS
       </code>
      </a>
      statement
          displays a row for each loaded plugin. Any that have a
      <code class="literal">
       Library
      </code>
      value of
      <code class="literal">
       NULL
      </code>
      are built in and cannot be unloaded.
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa70155288"><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 prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">PLUGINS</span>\G
<span class="token output"><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 1. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
   Name<span class="token punctuation">:</span> binlog
 Status<span class="token punctuation">:</span> ACTIVE
   Type<span class="token punctuation">:</span> STORAGE ENGINE
Library<span class="token punctuation">:</span> NULL
License<span class="token punctuation">:</span> GPL
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 2. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
   Name<span class="token punctuation">:</span> mysql_native_password
 Status<span class="token punctuation">:</span> ACTIVE
   Type<span class="token punctuation">:</span> AUTHENTICATION
Library<span class="token punctuation">:</span> NULL
License<span class="token punctuation">:</span> GPL
...</span></code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      The
      <code class="literal">
       mysql.plugin
      </code>
      table shows which plugins
          have been registered with
      <a class="link" href="install-plugin.html" title="15.7.4.4 INSTALL PLUGIN Statement">
       <code class="literal">
        INSTALL
          PLUGIN
       </code>
      </a>
      . The table contains only plugin names and
          library file names, so it does not provide as much information
          as 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 or the
      <a class="link" href="show-plugins.html" title="15.7.7.27 SHOW PLUGINS Statement">
       <code class="literal">
        SHOW PLUGINS
       </code>
      </a>
      statement.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
