mariadb - What is plugins and how it is work in mysql? -

i explore partition in mysql official site (https://dev.mysql.com/doc/refman/5.1/en/partitioning.html). in first page, found plugins.

mysql> show plugins; +----------------------------+----------+--------------------+---------+---------+ | name                       | status   | type               | library | license | +----------------------------+----------+--------------------+---------+---------+ | binlog                     | active   | storage engine     | null    | gpl     | | mysql_native_password      | active   | authentication     | null    | gpl     | | mysql_old_password         | active   | authentication     | null    | gpl     | | sha256_password            | active   | authentication     | null    | gpl     | | myisam                     | active   | storage engine     | null    | gpl     | | mrg_myisam                 | active   | storage engine     | null    | gpl     | | memory                     | active   | storage engine     | null    | gpl     | | csv                        | active   | storage engine     | null    | gpl     | | innodb                     | active   | storage engine     | null    | gpl     | | innodb_trx                 | active   | information schema | null    | gpl     | | innodb_locks               | active   | information schema | null    | gpl     | | innodb_lock_waits          | active   | information schema | null    | gpl     | | innodb_cmp                 | active   | information schema | null    | gpl     | | innodb_cmp_reset           | active   | information schema | null    | gpl     | | innodb_cmpmem              | active   | information schema | null    | gpl     | | innodb_cmpmem_reset        | active   | information schema | null    | gpl     | | innodb_cmp_per_index       | active   | information schema | null    | gpl     | | innodb_cmp_per_index_reset | active   | information schema | null    | gpl     | | innodb_buffer_page         | active   | information schema | null    | gpl     | | innodb_buffer_page_lru     | active   | information schema | null    | gpl     | | innodb_buffer_pool_stats   | active   | information schema | null    | gpl     | | innodb_metrics             | active   | information schema | null    | gpl     | | innodb_ft_default_stopword | active   | information schema | null    | gpl     | | innodb_ft_deleted          | active   | information schema | null    | gpl     | | innodb_ft_being_deleted    | active   | information schema | null    | gpl     | | innodb_ft_config           | active   | information schema | null    | gpl     | | innodb_ft_index_cache      | active   | information schema | null    | gpl     | | innodb_ft_index_table      | active   | information schema | null    | gpl     | | innodb_sys_tables          | active   | information schema | null    | gpl     | | innodb_sys_tablestats      | active   | information schema | null    | gpl     | | innodb_sys_indexes         | active   | information schema | null    | gpl     | | innodb_sys_columns         | active   | information schema | null    | gpl     | | innodb_sys_fields          | active   | information schema | null    | gpl     | | innodb_sys_foreign         | active   | information schema | null    | gpl     | | innodb_sys_foreign_cols    | active   | information schema | null    | gpl     | | innodb_sys_tablespaces     | active   | information schema | null    | gpl     | | innodb_sys_datafiles       | active   | information schema | null    | gpl     | | performance_schema         | active   | storage engine     | null    | gpl     | | federated                  | disabled | storage engine     | null    | gpl     | | archive                    | active   | storage engine     | null    | gpl     | | blackhole                  | active   | storage engine     | null    | gpl     | | partition                  | active   | storage engine     | null    | gpl     | +----------------------------+----------+--------------------+---------+---------+ 42 rows in set (0.05 sec) 

in mind having questions

1. what plugins ?
2. how work ?
3. how plugin available mysql?
4. can add other plugins ?
5. if can add how add ?

after analysis plugin, found more thing it. explain in deep.

what plugins , how work?

mysql supports plugin api enables creation of server components. plugins can loaded @ server startup, or loaded , unloaded @ runtime without restarting server. api generic , not specify plugins can do. components supported interface include, not limited to, storage engines, full-text parser plugins, , server extensions.

for example, full-text parser plugins can used replace or augment built-in full-text parser. plugin can parse text words using rules differ used built-in parser. can useful if need parse text characteristics different expected built-in parser.

the plugin interface more general older user-defined function (udf) interface.

how plugin available mysql? (types of plugins)

the plugin api enables creation of plugins implement several capabilities:

• storage engines
• full-text parsers
• daemons
• information_schema tables
• semisynchronous replication
• auditing
• authentication
• password validation , strength checking
• protocol tracing
• query rewriting

can add other plugins ? / if can add how add ?

plugins installed install plugin statement:

a plugin located in plugin library file can loaded @ runtime install plugin statement. statement registers plugin in mysql.plugin table cause server load on subsequent restarts. reason, install plugin requires insert privilege mysql.plugin table.

mysql> install plugin myplugin soname 'somepluglib.so'; 

uninstalling plugins

at runtime, uninstall plugin statement disables , uninstalls plugin known server. statement unloads plugin , removes mysql.plugin table, if registered there. reason, uninstall plugin statement requires delete privilege mysql.plugin table. plugin no longer registered in table, server not load plugin automatically subsequent restarts.