MySQL 8 中的分区表

如果已经存在数据，操作前记得备份数据

将现有表转换为范围分区表

ALTER TABLE table_name PARTITION BY RANGE COLUMNS(date) (
    PARTITION p1 VALUES LESS THAN ('2020-01-01'),
    PARTITION p2 VALUES LESS THAN ('2020-02-01'),
    PARTITION p3 VALUES LESS THAN ('2020-03-01'),
    PARTITION p4 VALUES LESS THAN (MAXVALUE)
);

将现有表转换为HASH分区表

1	ALTER TABLE table_name PARTITION BY HASH(column_name) PARTITIONS 10;

查看分区表状态：

SELECT partition_name, partition_ordinal_position, partition_method, partition_expression, partition_description, table_rows FROM information_schema.partitions WHERE table_schema = 'mirage' AND table_name = 'table_name';

本文采用署名-非商业性使用-相同方式共享 4.0 国际许可协议，转载请注明出处。