阅读(1198)
赞(1)
Mycat2 哈希分片 WEEK
2021-09-08 14:00:02 更新
WEEK
仅用于分表
仅DATE/DATETIME
一周之中的星期(1-7)进行取余运算
tbpartitions
不超过7
create table travelrecord (
....
) ENGINE=InnoDB DEFAULT CHARSET=utf8
dbpartition by xxx(xx) dbpartitions 8
tbpartition by WEEK(xx) tbpartitions 7;