Skip to content

[哈希分片]MM

jamie12221 edited this page Nov 29, 2020 · 1 revision

[数据分片]HASH型分片算法-MM

MM

仅用于分表

仅支持DATE/DATETIME

月份(1-12)%分表数

tbpartitions不超过12

create table travelrecord (
 ....
) ENGINE=InnoDB DEFAULT CHARSET=utf8 
dbpartition by xxx(xxx) dbpartition 12
tbpartition by MM(xxx) tbpartitions 12;
Clone this wiki locally