mysql分拆pmax_mysql pmax 分区

mysql> show create table ClientActionTrack\G;

*************************** 1. row ***************************

Table: ClientActionTrack

Create Table: CREATE TABLE `ClientActionTrack` (

`sn` bigint(20) NOT NULL AUTO_INCREMENT,

`clientSn` int(11) DEFAULT NULL,

`ip` varchar(32) DEFAULT NULL,

`url` varchar(1000) DEFAULT NULL COMMENT 'request url',

`httpMethod` varchar(100) DEFAULT NULL COMMENT 'http method',

`requestParams` text COMMENT '请求参数',

`requestHeader` varchar(2000) DEFAULT NULL COMMENT '请求头信息',

`pageUrl` varchar(500) DEFAULT NULL COMMENT '页面Url',

`sessionId` varchar(100) DEFAULT NULL COMMENT 'session的Id',

`startTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '访问开始时间',

`completeTime` datetime DEFAULT NULL COMMENT '访问完成时间',

PRIMARY KEY (`sn`,`startTime`)

) ENGINE=InnoDB AUTO_INCREMENT=302754 DEFAULT CHARSET=utf8 COMMENT='用户访问记录表'

/*!50100 PARTITION BY RANGE (TO_DAYS(startTime))

(PARTITION p20150914 VALUES LESS THAN (736221) ENGINE = InnoDB,

PARTITION p20150915 VALUES LESS THAN (736222) ENGINE = InnoDB,

PARTITION p20150916 VALUES LESS THAN (736223) ENGINE = InnoDB,

PARTITION p20150917 VALUES LESS THAN (736224) ENGINE = InnoDB,

PARTITION p20150918 VALUES LESS THAN (736225) ENGINE = InnoDB,

PARTITION p20150919 VALUES LESS THAN (736226) ENGINE = InnoDB,

PARTITION p20150920 VALUES LESS THAN (736227) ENGINE = InnoDB,

PARTITION p20150921 VALUES LESS THAN (736228) ENGINE = InnoDB,

PARTITION p20150922 VALUES LESS THAN (736229) ENGINE = InnoDB,

PARTITION p20150923 VALUES LESS THAN (736230) ENGINE = InnoDB,

PARTITION p20150924 VALUES LESS THAN (736231) ENGINE = InnoDB,

PARTITION p20150925 VALUES LESS THAN (736232) ENGINE = InnoDB,

PARTITION p20150926 VALUES LESS THAN (736233) ENGINE = InnoDB,

PARTITION p20150927 VALUES LESS THAN (736234) ENGINE = InnoDB,

PARTITION p20150928