mysql按月分区:
PARTITION s201612 VALUES LESS THAN (TO_DAYS('2017-01-01 ')),
PARTITION s201701 VALUES LESS THAN (TO_DAYS('2017-02-01')),
PARTITION s201702 VALUES LESS THAN (TO_DAYS('2017-03-01 ')),
PARTITION s201703 VALUES LESS THAN (TO_DAYS('2017-04-01 ')),
PARTITION s201704 VALUES LESS THAN (TO_DAYS('2017-05-01 ')),
PARTITION s201705 VALUES LESS THAN (TO_DAYS('2017-06-01 ')),
PARTITION s201706 VALUES LESS THAN (TO_DAYS('2017-07-01')),
PARTITION p2 VALUES LESS THAN MAXVALUE
查询分区情况:
SELECT
partition_name part,
partition_expression expr,
partition_description descr,
table_rows
FROM
INFORMATION_SCHEMA.partitions
WHERE
TABLE_SCHEMA = schema()
AND TABLE_NAME='table_ym';
s201701显示table_rows是65,而实际上这个分区的数据是77。当删除这个分区的时候实际上删除的也是77条数据。通过人肉此分区的数据发现,table_rows未显示的12条时间都是20170101 。应该怎么解决查询分区情况显示的分区数与实际不符?