tidb版本:3.0.11
我们生产创建了一张分区表:
CREATE TABLE `t_device_request` (
`REQUEST_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`CHANNEL` char(1) NOT NULL DEFAULT '' COMMENT '',
`REQUEST_TYPE` varchar(50) NOT NULL COMMENT '',
`CLIENT_TYPE` char(1) DEFAULT NULL COMMENT '',
`REQ_SEQ` varchar(50) DEFAULT NULL COMMENT '',
`ORI_SEQ` varchar(50) DEFAULT NULL,
`DSN` char(32) DEFAULT NULL,
`MERCHANT_ID` int(11) DEFAULT NULL,
`MERCH_NAME` varchar(50) DEFAULT NULL COMMENT '',
`STORE_ID` int(11) DEFAULT NULL,
`STORE_NAME` varchar(50) DEFAULT NULL COMMENT '',
`DEVICE_ID` int(11) DEFAULT NULL COMMENT '',
`DEVICE_ACCT` varchar(20) DEFAULT NULL COMMENT '',
`SUB_MERCHANT_ID` int(11) DEFAULT NULL COMMENT '',
`REQUEST_TIME` datetime NOT NULL COMMENT '',
`RESPONSE_TIME` datetime DEFAULT NULL COMMENT '',
`RESULT` char(1) DEFAULT NULL COMMENT '',
`CODE` varchar(6) DEFAULT NULL,
`MSG` varchar(100) DEFAULT NULL COMMENT '',
`PROCESS_COST` int(11) NOT NULL DEFAULT '0' COMMENT '',
PRIMARY KEY (`REQUEST_ID`,`REQUEST_TIME`),
KEY `INDEX_REQUEST_ORI_SEQ` (`ORI_SEQ`),
KEY `INDEX_REQUEST_REQ_SEQ` (`REQ_SEQ`),
KEY `INDEX_REQUEST_TIME` (`REQUEST_TIME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=92310001 COMMENT=''
PARTITION BY RANGE ( to_days(`request_time`) ) (
PARTITION p20200309 VALUES LESS THAN (737858),
PARTITION p20200316 VALUES LESS THAN (737865),
PARTITION p20200323 VALUES LESS THAN (737872),
PARTITION p20200330 VALUES LESS THAN (737879),
PARTITION p20200406 VALUES LESS THAN (737886),
PARTITION p20200413 VALUES LESS THAN (737893),
PARTITION p20200420 VALUES LESS THAN (737900),
PARTITION p20200427 VALUES LESS THAN (737907),
PARTITION p20200504 VALUES LESS THAN (737914),
PARTITION p20200511 VALUES LESS THAN (737921),
PARTITION p20200518 VALUES LESS THAN (737928),
PARTITION p20200525 VALUES LESS THAN (737935),
PARTITION p20200601 VALUES LESS THAN (737942)
)
我查询了最大的分区键和最小的 都没超过这个时间:
但是tidb.log一直报错
[2020/05/04 21:43:53.711 +08:00] [WARN] [partition.go:185] ["partition pruning not applicable"] [expression=to_days(
request_time)]
基本上每天200M的日志全是它报的WARN
是我分区有问题吗?其他没日志了,偶尔一些其他看起来和分区无关的错误。