it leader
article thumbnail

 

 

파티션 조회

<sql />
select * from information_schema.partitions where table_name = '테이블명'

 

파티션 추가

<sql />
alter table '테이블명' add partition ( PARTITION `파티션명` VALUES LESS THAN (파티션 값) }

 

파티션 재구성

<sql />
alter table `테이블명` REORGANIZE PARTITION partition list INTO ( PARTITION p_202001 VALUES LESS THAN ('2020-01-31'), PARTITION p_202002 VALUES LESS THAN ('2020-02-28'), PARTITION p_202003 VALUES LESS THAN ('2020-03-31') }

 

파티션 삭제

<sql />
ALTER TABLE `테이블명` DROP PARTITION '파티션명'
profile

it leader

@dev__pixui

포스팅이 좋았다면 "좋아요❤️" 또는 "구독👍🏻" 해주세요!