SELECT
table_name,
COUNT(DISTINCT partition_ordinal_position) AS num_partitions
FROM
information_schema.partitions
GROUP BY
table_name
HAVING
num_partitions > 1;
查看MYSQL数据库哪些表使用了分区
最新推荐文章于 2024-01-05 20:16:39 发布