1、查看分区情况

SELECT PARTITION_NAME,TABLE_ROWS FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_NAME = 'tablename';

2、分区 2-1时间戳 alter table tablename algorithm=inplace, lock=none, drop primary key, add primary key (id, time);
alter table tablename partition by range columns (time) (
    partition p1711 values less than (1512057599),
    partition p1712 values less than (1514735999),
    partition p0 values less than maxvalue
);   2-2字符串 alter table xw_user_applyloan_baoxian algorithm=inplace, lock=none, drop primary key, add primary key (id, time);
alter table tablename partition by range columns (UNIX_TIMESTAMP(time）) (
    partition p1711 values less than (UNIX_TIMESTAMP('2007-11-30 23:59:59')),
    partition p1712 values less than (UNIX_TIMESTAMP('2007-12-31 23:59:59')),
    partition p0 values less than maxvalue
);  
分区说明：如果有表中有主键，分区的字段也是需要设置为主键

转载于:https://www.cnblogs.com/dawuge/p/9046664.html

原文链接：https://blog.csdn.net/weixin_30342827/article/details/94811393

本站声明:网站内容来源于网络,如有侵权,请联系我们,我们将及时处理。