MySQL(Plugins)

最新推荐文章于 2024-07-09 09:45:00 发布

weixin_34395205

最新推荐文章于 2024-07-09 09:45:00 发布

阅读量434

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 python

原文链接：https://my.oschina.net/igooglezm/blog/847982

本文介绍了MySQL中各种插件的安装配置方法及管理命令，包括认证插件、连接控制插件等，并详细列举了插件目录下的文件及插件表格中的各项内容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

2019独角兽企业重金招聘Python工程师标准>>>

install and config plugins( my.cnf )

  --plugin_name[=activation_state]

plugin table:

  select * from mysql.plugin

plugin dir:/usr/lib/mysql/plugin/

adt_null.so
auth_socket.so
connection_control.so
group_replication.so
innodb_engine.so
keyring_file.so
keyring_udf.so
libmemcached.so
libpluginmecab.so
locking_service.so
mypluglib.so
mysql_no_login.so
mysqlx.so
rewriter.so
semisync_master.so
semisync_slave.so
validate_password.so
version_token.so

plugins:

authentication plugin

connection-control plugin

password validation plugin

group replication plugin

thread pool plugin(enterprise)
    The default thread-handling model in MySQL Server executes statements using one thread per client connection

audit plugin(enterprise)

firewall plugin(enterprise)
    application-level firewall

query rewrite plugin
    preparse query rewrite plugin
    postparse query rewrite plugin

version tokens plugin

keyring plugin

X plugin

semisynchronous replication

test framework plugin
test services plugin
test services threaded pligun

转载于:https://my.oschina.net/igooglezm/blog/847982