通过以下SHOW VARIABLES
语句确定您的MySQL服务器是否支持分区:
show variables like '%partition%';
注意该
have_partitioning
变量已弃用,并在MySQL 5.6.1中删除。
SELECT PLUGIN_NAME AS NAME, PLUGIN_VERSION AS Version, PLUGIN_STATUS AS STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_TYPE = 'STORAGE ENGINE';