mysql怎么查看是否支持分区

mysql查看是否支持分区的方法：执行【show plugins like '%partiotion%';】语句，如果输出信息【empty set】，则表示不支持分区。mysql从5.1版本开始支持分区功能。
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 || innodb | 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 | nul

阿里云服务器扩大硬盘容量
定制公司网站建设的步骤是怎样的 需要花费多少费用
[原创]嘉兴企业利用企业建设网站拓展业务需注意的六个方面是什么
seo二级目录与站内站的区别
能把营业执照撤下么没有拍好
自建服务器云主机哪个费用低点
网站建设详细报价是怎样的？网站建设如何挖掘关键词
中文顶级域名有哪些？中文域名有什么优势？