Skip to content

Add sharding key triggers to uploads partitions

What does this MR do and why?

  • Add sharding key triggers to uploads partitions according to this proposal.
  • Add missing uploads_sharding_key

Addresses #398199

Dependency Partition Trigger Sharding Key
abuse_reports

abuse_report_uploads

trigger_3434b82e5e12

organization_id

achievements

achievement_uploads

trigger_cca6a43d90dd

namespace_id

ai_vectorizable_files

ai_vectorizable_file_uploads

trigger_fcc3ea1f9d4e

project_id

alert_management_alert_metric_images

alert_management_alert_metric_image_uploads

trigger_47c43d40f0d2

project_id

appearances (gitlab_main_cell_setting)

appearance_uploads (gitlab_main_cell_setting)

schema: gitlab_main_cell_setting -> Cell-local, unsharded table

bulk_import_export_uploads

bulk_import_export_upload_uploads

trigger_c40a5bb7c1c3

trigger_d32ff9d5c63d

project_id

namespace_id

dependency_list_export_parts (gitlab_sec)

dependency_list_export_part_uploads (gitlab_main_org)

organization_id

dependency_list_exports (gitlab_sec)

dependency_list_export_uploads (gitlab_main_org)

project_id

namespace_id

organization_id

design_management_designs_versions

design_management_action_uploads

trigger_c24a252f7b04

namespace_id

import_export_uploads

import_export_upload_uploads

trigger_1a41d368edd5

trigger_1a052e65e9d9

project_id

namespace_id

issuable_metric_images

issuable_metric_image_uploads

trigger_e740510cfd33

namespace_id

namespaces

namespace_uploads

trigger_442d030cfdfe

namespace_id

organization_details

organization_detail_uploads

trigger_1825cdc71779

organization_id

project_relation_export_uploads

project_import_export_relation_export_upload_uploads

trigger_f468204dcd5d

project_id

topics

project_topic_uploads

trigger_4f1b6c76fdfc

organization_id

projects

project_uploads

trigger_38b6d9d97935

project_id

snippets

snippet_uploads

trigger_a68471fea292

organization_id

user_permission_export_uploads

user_permission_export_upload_uploads

trigger_67d0d39e2f41

uploaded_by_user_id (users)

users

user_uploads

trigger_25ba78722e56

organization_id

vulnerability_archive_exports (gitlab_sec)

vulnerability_archive_export_uploads (gitlab_main_org)

project_id

vulnerability_export_parts (gitlab_sec)

vulnerability_export_part_uploads (gitlab_main_org)

organization_id

vulnerability_exports (gitlab_sec)

vulnerability_export_uploads (gitlab_main_org)

organization_id

vulnerability_remediations (gitlab_sec)

vulnerability_remediation_uploads (gitlab_main_org)

project_id

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Tomasz Skorupa

Merge request reports

Loading