問題描述

CREATE TABLE `yy_subscribe2` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL comment ’用戶id’, `book_id` int(10) unsigned NOT NULL comment ’小說id’, `chapter_id` int(10) unsigned NOT NULL comment ’章節(jié)id’, PRIMARY KEY (`id`), key book_id(book_id), key user_id(user_id), key chapter_id(chapter_id)) ENGINE=InnoDB DEFAULT CHARSET=utf8 PARTITION BY RANGE (user_id)?(? PARTITION s0 values LESS THAN (100000), PARTITION s1 values LESS THAN (200000), PARTITION s2 values LESS THAN (300000), PARTITION s3 values LESS THAN (400000), PARTITION s4 values LESS THAN (500000), PARTITION s5 values LESS THAN (600000), PARTITION s6 values LESS THAN (700000), PARTITION s7 values LESS THAN (800000), PARTITION s8 values LESS THAN (900000), PARTITION s9 values LESS THAN (1000000), PARTITION s10 values LESS THAN (1100000), PARTITION s11 values LESS THAN (1200000), PARTITION s12 values LESS THAN (1300000), PARTITION s13 values LESS THAN (1400000),? PARTITION s999 values LESS THAN MAXVALUE);

mysql 建立分區(qū)報(bào)這個(gè)錯(cuò)：For RANGE partitions each partition must be defined 。是什么原因。

另外這是一張小說的章節(jié)訂閱表。用來記錄用戶訂閱了哪本書的哪一章。目前已有3000W條數(shù)據(jù)。索引已經(jīng)做了。打算用分區(qū)是否對(duì)后續(xù)的數(shù)據(jù)增長有效果？還是不用分區(qū)用別的方式？

問題解答

mysql建分區(qū)暫時(shí)沒玩過，會(huì)不會(huì)是你語法上有寫錯(cuò)，再排查一下；另外 訂閱的 這種需求現(xiàn)在好像都推薦用redis這種nosql來玩。