Syntax
------

SHOW PLUGINS SONAME { library | LIKE 'pattern' | WHERE expr };

Description
-----------

SHOW PLUGINS SONAME displays information about compiled-in and all server
plugins in the plugin_dir directory, including plugins that haven't been
installed.

Examples
--------

SHOW PLUGINS SONAME 'ha_example.so';
+----------+---------------+----------------+---------------+---------+
| Name     | Status        | Type           | Library       | License |
+----------+---------------+----------------+---------------+---------+
| EXAMPLE  | NOT INSTALLED | STORAGE ENGINE | ha_example.so | GPL     |
| UNUSABLE | NOT INSTALLED | DAEMON         | ha_example.so | GPL     |
+----------+---------------+----------------+---------------+---------+

There is also a corresponding information_schema table, called ALL_PLUGINS,
which contains more complete information.

URL: https://mariadb.com/kb/en/show-plugins-soname/