mysql分区2

CREATE TABLE `test2` (
  `id` bigint(19) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `name1` varchar(200) DEFAULT NULL,
  `cre_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name_index1` (`name`),
  KEY `name1_index1` (`name1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8


PARTITION BY RANGE (id)

SUBPARTITION BY HASH(id) (


   PARTITION p0 VALUES LESS THAN (1000000)(
            SUBPARTITION s0   DATA DIRECTORY '/data/data_sub1' INDEX DIRECTORY '/data/index_sub1' ,
            SUBPARTITION s1   DATA DIRECTORY '/data/data_sub1' INDEX DIRECTORY '/data/index_sub1'
),
    PARTITION p1 VALUES LESS THAN (2000000)(
            SUBPARTITION s2 DATA DIRECTORY '/data/data_sub2' INDEX DIRECTORY '/data/index_sub2' ,
            SUBPARTITION s3 DATA DIRECTORY '/data/data_sub2' INDEX DIRECTORY '/data/index_sub2'
),
    PARTITION p2 VALUES LESS THAN (3000000)(
            SUBPARTITION s4 DATA DIRECTORY '/data/data_sub3' INDEX DIRECTORY '/data/index_sub3' ,
            SUBPARTITION s5 DATA DIRECTORY '/data/data_sub3' INDEX DIRECTORY '/data/index_sub3'
),
    PARTITION p3 VALUES LESS THAN (4000000)(
            SUBPARTITION s6 DATA DIRECTORY '/data/data_sub4' INDEX DIRECTORY '/data/index_sub4' ,
            SUBPARTITION s7 DATA DIRECTORY '/data/data_sub4' INDEX DIRECTORY '/data/index_sub4'
),
    PARTITION p4 VALUES LESS THAN (5000000)(
            SUBPARTITION s8 DATA DIRECTORY '/data/data_sub5' INDEX DIRECTORY '/data/index_sub5' ,
            SUBPARTITION s9 DATA DIRECTORY '/data/data_sub5' INDEX DIRECTORY '/data/index_sub5'
),
    PARTITION p5 VALUES LESS THAN (6000000)(
            SUBPARTITION s10 DATA DIRECTORY '/data/data_sub6' INDEX DIRECTORY '/data/index_sub6' ,
            SUBPARTITION s11 DATA DIRECTORY '/data/data_sub6' INDEX DIRECTORY '/data/index_sub6'
),
    PARTITION p6 VALUES LESS THAN (7000000)(
            SUBPARTITION s12 DATA DIRECTORY '/data/data_sub7' INDEX DIRECTORY '/data/index_sub7' ,
            SUBPARTITION s13 DATA DIRECTORY '/data/data_sub7' INDEX DIRECTORY '/data/index_sub7'
),
    PARTITION p7 VALUES LESS THAN (8000000)(
            SUBPARTITION s14 DATA DIRECTORY '/data/data_sub8' INDEX DIRECTORY '/data/index_sub8' ,
            SUBPARTITION s15 DATA DIRECTORY '/data/data_sub8' INDEX DIRECTORY '/data/index_sub8'
),
    PARTITION p8 VALUES LESS THAN (9000000)(
            SUBPARTITION s16 DATA DIRECTORY '/data/data_sub9' INDEX DIRECTORY '/data/index_sub9' ,
            SUBPARTITION s17 DATA DIRECTORY '/data/data_sub9' INDEX DIRECTORY '/data/index_sub9'
),
   
    PARTITION p9 VALUES LESS THAN (MAXVALUE)(
            SUBPARTITION s18 DATA DIRECTORY '/data/data_sub10' INDEX DIRECTORY '/data/index_sub10' ,
            SUBPARTITION s19 DATA DIRECTORY '/data/data_sub10' INDEX DIRECTORY '/data/index_sub10'
)
);