What’s the best of adding more partitions to my already partitioned tables. I am trying to use pt-online -schema change to alter these tables and add more partitions to the partitions scheme I have. I found out that using pt-online-schema -change it still involves copying the data over and it’s taking time. Reorganize kinda work fine but still want know if that’s best approach
Did you try a simple
ALTER TABLE .. ADD PARTITION (< new partition definition >);
Simply adding more partitions might be an online operation in MySQL 8, but test that first on a copy.
Yes, pt-osc will always copy the data, no matter what the change is.