mysql查看是否支持分区的方法

小编给大家分享一下mysql查看是否支持分区的方法，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！

mysql查看是否支持分区的方法：执行【show plugins like '%partiotion%';】语句，如果输出信息【Empty set】，则表示不支持分区。mysql从5.1版本开始支持分区功能。

mysql从5.1开始支持分区功能。

查询命令如下：

mysql> show plugins like '%partiotion%';mysql> show variables like '%partition%';Empty set (0.00 sec)

如果查询结果显示Empty，表示不支持分区。

但是上面的查询方法只是针对mysql5.6以下版本。

如果mysql5.6以及以上版本，需要使用下面的查询命令：

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     || MRG_MYISAM                 | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     || MEMORY                     | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     || CSV                        | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     || MyISAM                     | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     || ARCHIVE                    | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     || BLACKHOLE                  | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     || PERFORMANCE_SCHEMA         | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     || FEDERATED                  | DISABLED | 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     || partition                  | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |+----------------------------+----------+--------------------+---------+---------+42 rows in set (0.00 sec)

上面的查询方法会显示所有插件，如果有如下内容，表示支持分区。

partition      | ACTIVE   | STORAGE ENGINE     | NULL    | GPL

以上是mysql查看是否支持分区的方法的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注行业资讯频道！