Switch current partition_id value to 101 for ci_builds_metadata and ci_builds
For the p_ci_builds_metadata table we have two partitions:
ci_builds_metadata FOR VALUES IN ('100')gitlab_partitions_dynamic.ci_builds_metadata_101 FOR VALUES IN ('101')
Switching partition_id to 101 will stop the growth of the ci_builds_metadata table because the new records will be persisted in the ci_builds_metadata_101 table.
We should also stop the growth of ci_builds table once we implement our second partition for it #416457 (closed).
Proposal:
-
create a plan to make sure that it doesn't take down production -
prepare a plan for recovering from the unexpected -
make the change
Edited by Caroline Simpson