1.查询mysql的版本
select version();
结果显示:
5.7.17-log
2.在mysql5.6及以后版本检查是否开启分区表的方法一
SHOW PLUGINS ;
结果 partition表示分区表, ENGINE 表示开启,
partition ACTIVE STORAGE ENGINE GPL
2.在mysql5.6及以上版本检查是否支持分区表的方法二
SELECT PLUGIN_NAME AS NAME,
PLUGIN_VERSION AS VERSION,
PLUGIN_STATUS AS STATUS
FROM INFORMATION_SCHEMA.PLUGINS
WHERE PLUGIN_TYPE='STORAGE ENGINE';
| partition | 1.0 | ACTIVE |
3.在mysql5.1到5.5版本检查是否开启分区表的方法
SHOW VARIABLES LIKE '%partition%';
显示结果为:YES 为支持分区表
+-----------------------+-------+
| Variable_name | Value |
+-----------------------+-------+
| have_partition_engine | YES |
+-----------------------+-------+