通过以下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';