Note
This view is introduced since V4.3.5 BP1.
Purpose
Displays the plugin list and detailed information of each plugin.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the node where the replica resides. |
| SVR_PORT | bigint(20) | NO | The port number of the replica. |
| NAME | varchar(64) | YES | The name of the plugin. |
| STATUS | varchar(64) | YES | The status of the plugin:
|
| TYPE | varchar(80) | YES | The type of the plugin: FTPARSER (word segmentation plugin). |
| LIBRARY | varchar(128) | YES | The name of the plugin dynamic link library (built-in plugins do not have corresponding link libraries). |
| LIBRARY_VERSION | varchar(80) | YES | The version of the plugin base library that this plugin depends on. |
| LIBRARY_REVISION | varchar(80) | YES | The revision version of the plugin library. |
| INTERFACE_VERSION | varchar(80) | YES | The specific interface API version implemented by this plugin. |
| AUTHOR | varchar(64) | YES | The author information of the plugin. |
| LICENSE | varchar(64) | YES | The license of the plugin. |
| DESCRIPTION | varchar(65535) | YES | The description of the plugin. |
Query example
In the sys tenant, view the list of all plugins and their detailed information.
obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_PLUGINS;
The query result is as follows:
+-----------------+----------+--------+--------+----------+---------+-----------------+------------------+-------------------+-----------------------+------------+---------------------------------------------------------------------------------------------+
| SVR_IP | SVR_PORT | NAME | STATUS | TYPE | LIBRARY | LIBRARY_VERSION | LIBRARY_REVISION | INTERFACE_VERSION | AUTHOR | LICENSE | DESCRIPTION |
+-----------------+----------+--------+--------+----------+---------+-----------------+------------------+-------------------+-----------------------+------------+---------------------------------------------------------------------------------------------+
| xxx.xxx.xxx.128 | 2882 | ngram | READY | FTPARSER | NULL | 0.0.1 | NULL | 0.2.0 | OceanBase Corporation | Apache 2.0 | This is a ngram fulltext parser plugin. |
| xxx.xxx.xxx.128 | 2882 | beng | READY | FTPARSER | NULL | 0.0.1 | NULL | 0.2.0 | OceanBase Corporation | Apache 2.0 | This is a basic english parser plugin. |
| xxx.xxx.xxx.128 | 2882 | space | READY | FTPARSER | NULL | 0.0.1 | NULL | 0.2.0 | OceanBase Corporation | Apache 2.0 | This is a default whitespace parser plugin. |
| xxx.xxx.xxx.128 | 2882 | ngram2 | READY | FTPARSER | NULL | 0.0.1 | NULL | 0.2.0 | OceanBase Corporation | Apache 2.0 | This is a range ngram fulltext parser plugin.It is used to parse fulltext with range ngram. |
| xxx.xxx.xxx.128 | 2882 | ik | READY | FTPARSER | NULL | 0.0.1 | NULL | 0.2.0 | OceanBase Corporation | Apache 2.0 | This is an ik parser plugin. |
+-----------------+----------+--------+--------+----------+---------+-----------------+------------------+-------------------+-----------------------+------------+---------------------------------------------------------------------------------------------+
5 rows in set