在原最大分区基础上再增加分区方法
`id` bigint(25) NOT NULL AUTO_INCREMENT COMMENT '主键值，最大值超过亿',
`book_id` int(10) NOT NULL COMMENT '课本id',
`lesson_id` int(10) NOT NULL COMMENT '课文id',
`group_id` int(10) DEFAULT NULL COMMENT '词组id',
`word` varchar(10) DEFAULT NULL COMMENT '听写的汉字',
`spell` varchar(15) DEFAULT NULL COMMENT '汉字拼音',
`is_finished` tinyint(4) DEFAULT NULL COMMENT '是否已完成（0未完成，1已经完成）',
`user_id` varchar(25) DEFAULT NULL COMMENT '用户id',
`judge_result` varchar(20) DEFAULT NULL COMMENT '判断结果',
`breviary_url` varchar(200) DEFAULT NULL COMMENT '缩略图路径',
`stroke_order` varchar(100) DEFAULT NULL COMMENT '笔画顺序',
`module` varchar(5) DEFAULT NULL COMMENT '机型',
`machine_id` varchar(25) DEFAULT NULL COMMENT '机器序列号',
`create_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`,`create_time`),
KEY `idx_userid` (`user_id`),
KEY `idx_lessonid` (`lesson_id`),
KEY `uniq_userid_word` (`user_id`,`create_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=37661257 DEFAULT CHARSET=utf8
/*!50100 PARTITION BY RANGE (to_days(create_time))
(PARTITION p1 VALUES LESS THAN (736420) ,
PARTITION p2 VALUES LESS THAN (736450) ,
PARTITION p3 VALUES LESS THAN (736481) ,
PARTITION p4 VALUES LESS THAN (736511) ,
PARTITION p5 VALUES LESS THAN (736542) ,
PARTITION p6 VALUES LESS THAN (736573) ,
PARTITION p7 VALUES LESS THAN (736603) ,
PARTITION p8 VALUES LESS THAN (736634) ,
PARTITION p9 VALUES LESS THAN (736664) ,
PARTITION p10 VALUES LESS THAN (736695) ,
PARTITION p11 VALUES LESS THAN (736726) ,
PARTITION p12 VALUES LESS THAN (736754) ,
PARTITION p13 VALUES LESS THAN (736785) ,
PARTITION p14 VALUES LESS THAN (736815) ,
PARTITION p15 VALUES LESS THAN (736846) ,
PARTITION p16 VALUES LESS THAN (736876) ,
PARTITION p17 VALUES LESS THAN (736907) ,
PARTITION p18 VALUES LESS THAN (736938) ,
PARTITION p19 VALUES LESS THAN (736968) ,
PARTITION p20 VALUES LESS THAN (736999) ,
PARTITION p21 VALUES LESS THAN (737029) ,
PARTITION p22 VALUES LESS THAN (737060) ,
PARTITION p23 VALUES LESS THAN (737091) ,
PARTITION p24 VALUES LESS THAN (737119) ,
PARTITION p25 VALUES LESS THAN (737150) ,
PARTITION p26 VALUES LESS THAN (737180) ,
PARTITION p27 VALUES LESS THAN (737211) ,
PARTITION p28 VALUES LESS THAN (737241) ,
PARTITION p29 VALUES LESS THAN (737272) ,
PARTITION p30 VALUES LESS THAN (737303) ,
PARTITION p31 VALUES LESS THAN (737333) ,
PARTITION p32 VALUES LESS THAN (737364) ,
PARTITION p33 VALUES LESS THAN (737394) ,
PARTITION p34 VALUES LESS THAN (737425) ,
PARTITION p35 VALUES LESS THAN (737456) ,
PARTITION p36 VALUES LESS THAN (737484) ,
PARTITION p37 VALUES LESS THAN (737515) ,
PARTITION p38 VALUES LESS THAN (737545) ,
PARTITION p39 VALUES LESS THAN (737576) ,
PARTITION p40 VALUES LESS THAN (737606) ,
PARTITION p41 VALUES LESS THAN (737637) ,
PARTITION p42 VALUES LESS THAN (737668) ,
PARTITION p43 VALUES LESS THAN (737698) ,
PARTITION p44 VALUES LESS THAN (737729) ,
PARTITION p45 VALUES LESS THAN (737759) ,
PARTITION p46 VALUES LESS THAN MAXVALUE ) */;
按理说这种是没法分区的，但是还是可以分区的，
ALTER TABLE t_user_worditem_record
REORGANIZE PARTITION p1 ,p2 ,p3 ,p4 ,p5 ,p6 ,p7 ,p8 ,p9 ,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31,p32,p33,p34,p35,p36,p37,p38,p39,p40,
p41,p42,p43,p44,p45,p46
INTO (
PARTITION p1 VALUES LESS THAN (736420) ,
PARTITION p2 VALUES LESS THAN (736450) ,
PARTITION p3 VALUES LESS THAN (736481) ,
PARTITION p4 VALUES LESS THAN (736511) ,
PARTITION p5 VALUES LESS THAN (736542) ,
PARTITION p6 VALUES LESS THAN (736573) ,
PARTITION p7 VALUES LESS THAN (736603) ,
PARTITION p8 VALUES LESS THAN (736634) ,
PARTITION p9 VALUES LESS THAN (736664) ,
PARTITION p10 VALUES LESS THAN (736695) ,
PARTITION p11 VALUES LESS THAN (736726) ,
PARTITION p12 VALUES LESS THAN (736754) ,
PARTITION p13 VALUES LESS THAN (736785) ,
PARTITION p14 VALUES LESS THAN (736815) ,
PARTITION p15 VALUES LESS THAN (736846) ,
PARTITION p16 VALUES LESS THAN (736876) ,
PARTITION p17 VALUES LESS THAN (736907) ,
PARTITION p18 VALUES LESS THAN (736938) ,
PARTITION p19 VALUES LESS THAN (736968) ,
PARTITION p20 VALUES LESS THAN (736999) ,
PARTITION p21 VALUES LESS THAN (737029) ,
PARTITION p22 VALUES LESS THAN (737060) ,
PARTITION p23 VALUES LESS THAN (737091) ,
PARTITION p24 VALUES LESS THAN (737119) ,
PARTITION p25 VALUES LESS THAN (737150) ,
PARTITION p26 VALUES LESS THAN (737180) ,
PARTITION p27 VALUES LESS THAN (737211) ,
PARTITION p28 VALUES LESS THAN (737241) ,
PARTITION p29 VALUES LESS THAN (737272) ,
PARTITION p30 VALUES LESS THAN (737303) ,
PARTITION p31 VALUES LESS THAN (737333) ,
PARTITION p32 VALUES LESS THAN (737364) ,
PARTITION p33 VALUES LESS THAN (737394) ,
PARTITION p34 VALUES LESS THAN (737425) ,
PARTITION p35 VALUES LESS THAN (737456) ,
PARTITION p36 VALUES LESS THAN (737484) ,
PARTITION p37 VALUES LESS THAN (737515) ,
PARTITION p38 VALUES LESS THAN (737545) ,
PARTITION p39 VALUES LESS THAN (737576) ,
PARTITION p40 VALUES LESS THAN (737606) ,
PARTITION p41 VALUES LESS THAN (737637) ,
PARTITION p42 VALUES LESS THAN (737668) ,
PARTITION p43 VALUES LESS THAN (737698) ,
PARTITION p44 VALUES LESS THAN (737729) ,
PARTITION p45 VALUES LESS THAN (737759) ,
PARTITION p46 VALUES LESS THAN (737790) ,
PARTITION p47 VALUES LESS THAN MAXVALUE
)
通过REORGANIZE值来给最大分区下面再分区。
更多相关文章
- Mysql PARTITION 数据表分区技术
- Linux入门笔记之一：系统分区及挂载点
- linux挂载分区后重启失败
- linux中的磁盘分区
- 安装Linux系统的磁盘分区
- Linux下如何备份恢复和查看硬盘MBR与分区表
- Linux系统中使用fdisk命令为U盘分区，并将其中一个分区设置为启动
- JPA hibernate spring repository pgsql java 工程（三）：数据表分区
- 安卓+servlet+MySql 查询+插入（汉字乱码解决）