大佬教程收集整理的这篇文章主要介绍了使用 SHOW PLUGINS 命令过滤 MySQL 插件 概要问题,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
用于 MysqL 的 SHOW PLUGINS
命令返回 MysqL 8.0.25 上的表格数据集。我想使用 WHERE
子句过滤此数据集。当我尝试此操作时,出现语法错误。
这有效:
SHOW PLUGINS;
+---------------------------------+----------+--------------------+---------+---------+
| name | Status | Type | library | license |
+---------------------------------+----------+--------------------+---------+---------+
| binlog | ACTIVE | STORAGE ENGINE | NulL | GPL |
| MysqL_native_password | ACTIVE | AUTHENTICATION | NulL | GPL |
| sha256_password | ACTIVE | AUTHENTICATION | NulL | GPL |
| caching_sha2_password | ACTIVE | AUTHENTICATION | NulL | GPL |
| sha2_cache_cleaner | ACTIVE | AUDIT | NulL | GPL |
| daemon_keyring_proxy_plugin | ACTIVE | DAEMON | NulL | GPL |
| CSV | ACTIVE | STORAGE ENGINE | NulL | GPL |
| MEMORY | ACTIVE | STORAGE ENGINE | NulL | GPL |
| InnoDB | ACTIVE | STORAGE ENGINE | NulL | GPL |
| INNODB_TRX | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_CMP | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_CMP_reset | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_CMPMEM | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_CMPMEM_reset | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_CMP_PER_INDEX | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_CMP_PER_INDEX_reset | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_BUFFER_PAGE | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_BUFFER_PAGE_LRU | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_BUFFER_POol_STATS | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_TEMP_table_INFO | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_METRICS | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_FT_DEFAulT_StopWORD | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_FT_deletED | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_FT_BEING_deletED | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_FT_CONfig | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_FT_INDEX_CACHE | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_FT_INDEX_table | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_tableS | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_tableSTATS | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_INDEXES | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_tableSPACES | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_columNS | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_VIRTUAL | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_CACHED_INDEXES | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| INNODB_SESSION_TEMP_tableSPACES | ACTIVE | informatION scheR_394_11845@A | NulL | GPL |
| MyISAM | ACTIVE | STORAGE ENGINE | NulL | GPL |
| MRG_MYISAM | ACTIVE | STORAGE ENGINE | NulL | GPL |
| PERFORMANCE_scheR_394_11845@A | ACTIVE | STORAGE ENGINE | NulL | GPL |
| Temptable | ACTIVE | STORAGE ENGINE | NulL | GPL |
| ARCHIVE | ACTIVE | STORAGE ENGINE | NulL | GPL |
| BLACKHolE | ACTIVE | STORAGE ENGINE | NulL | GPL |
| FEDERATED | Disabled | STORAGE ENGINE | NulL | GPL |
| ngram | ACTIVE | FTPARSER | NulL | GPL |
| MysqLx_cache_cleaner | ACTIVE | AUDIT | NulL | GPL |
| MysqLx | ACTIVE | DAEMON | NulL | GPL |
+---------------------------------+----------+--------------------+---------+---------+
这不会:
SHOW PLUGINS WHERE Type = 'DAEMON';
#1064 - 您的 sql 语法有错误;检查与您的 MysqL 服务器版本相对应的手册,了解在第 1 行的“WHERE Type = 'DAEMON'”附近使用的正确语法
如何过滤 MysqL 8.0.25 服务器上的插件列表?
大多数 SHOW
命令都是对 INFORMATION_scheR_394_11845@A
中的某个表进行查询的别名,例如https://dev.mysql.com/doc/refman/8.0/en/information-scheR_394_11845@a-plugins-table.html
@H_827_5@mysql> SELEct * from information_scheR_394_11845@a.plugins where plugin_type = 'DAEMON'; +-------------+----------------+---------------+-------------+---------------------+----------------+------------------------+--------------------+--------------------+----------------+-------------+ | PLUGIN_NAME | PLUGIN_VERSION | PLUGIN_STATUS | PLUGIN_TYPE | PLUGIN_TYPE_VERSION | PLUGIN_LIBRARY | PLUGIN_LIBRARY_VERSION | PLUGIN_AUTHOR | PLUGIN_DESCRIPTION | PLUGIN_LICENSE | LOAD_OPTION | +-------------+----------------+---------------+-------------+---------------------+----------------+------------------------+--------------------+--------------------+----------------+-------------+ | mysqlx | 1.0 | ACTIVE | DAEMON | 80023.0 | NULL | NULL | Oracle Corporation | X Plugin for MySQL | GPL | ON | +-------------+----------------+---------------+-------------+---------------------+----------------+------------------------+--------------------+--------------------+----------------+-------------+ mysql> SELEct version(); +-----------+ | version() | +-----------+ | 8.0.23 | +-----------+
某些 SHOW
命令具有 WHERE
子句的语法,但并非全部如此。您可以在参考文档中查看哪些支持 WHERE
子句:https://dev.mysql.com/doc/refman/8.0/en/show.html
以上是大佬教程为你收集整理的使用 SHOW PLUGINS 命令过滤 MySQL 插件 概要问题全部内容,希望文章能够帮你解决使用 SHOW PLUGINS 命令过滤 MySQL 插件 概要问题所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。