tidb region拆分

聚簇表 region 拆分

CREATE TABLE `sbtest1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`k` int(11) NOT NULL DEFAULT '0',
`c` char(120) NOT NULL DEFAULT '',
`pad` char(60) NOT NULL DEFAULT '',
PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */,
KEY `k_1` (`k`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

split table sbtest1 between (0) and (100000) regions 3 ;

索引拆分

split table  sbtest1 index k_1 between(0)  and (99999999) regions 10;

非聚簇表region拆分

CREATE TABLE `sbtest2` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`k` int(11) NOT NULL DEFAULT '0',
`c` char(120) NOT NULL DEFAULT '',
`pad` char(60) NOT NULL DEFAULT '',
PRIMARY KEY (`id`) nonclustered,
KEY `k_1` (`k`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin shard_row_id_bits=4 pre_split_regions=3;
非聚簇表可以建表的时候拆分pre_split_regions=3  拆成8个region

索引拆分

split table  sbtest1 index k_1 between(0)  and (99999999) regions 10;