查询表的分区信息

SELECT
partition_name part,
partition_expression expr,
partition_description descr,
table_rows
FROM
information_schema. PARTITIONS
WHERE
table_schema = SCHEMA ()
AND table_name = 'test';

当询当前语句走了哪几个分区表

EXPLAIN PARTITIONS SELECT

类别:数据库 | 阅读:2122 | 评论:1 | 标签:mysql 数据库 表分区