MySQL表分区解决数据量过多导致查询缓慢的问题

MySQL ：当表数据量每天有数据更新，数据量特别大的情况下，将选择mySQL的表分区

---------------------- //第一步，建分区表时，对数据库操作,修正group by的错误
show variables like “sql_mode”;

set sql_mode=’’;
set sql_mode=‘NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES’;

------------------------ 查看分区
SELECT * FROM information_schema. PARTITIONS t
WHERE t.PARTITION_NAME IS NOT NULL;

----------------------- 删除分区，恢复原表
alter table indicator_history remove partitioning;

-----------------------建立分区,需要分区的主表如果存在id主键，那么分区时间字段也应设置为第二主键
ALTER TABLE indicator_history PARTITION BY RANGE (UNIX_TIMESTAMP(create_time))
(
PARTITION p20181201 VALUES LESS THAN (UNIX_TIMESTAMP(‘2018-11-21 00:00:00’)),
PARTITION p20181201 VALUES LESS THAN (UNIX_TIMESTAMP(‘2018-11-22 00:00:00’)),
PARTITION p20181201 VALUES LESS THAN (UNIX_TIMESTAMP(‘2018-11-23 00:00:00’)),
PARTITION p20181201 VALUES LESS THAN (UNIX_TIMESTAM