专注于云服务器
VPS主机优惠测评
国内免备案虚拟主机

mysql怎么查看是否支持分区

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

mysql怎么查看是否支持分区

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

(推荐教程:mysql教程

查询命令如下:

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

相关推荐:php培训

以上就是mysql怎么查看是否支持分区的详细内容,更多请关注名铺123其它相关文章!

赞(0) 打赏
转载请注明出处:晓波笔记 » mysql怎么查看是否支持分区
分享到: 更多 (0)
megalayer云服务器

raksmart云服务器

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

晓波笔记-VPS主机,云服务器优惠促销测评

QQ:87304394

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏