Closed Bug 1163588 Opened 10 years ago Closed 10 years ago

Defragment the objectstore tables now the data lifecycle has been reduced by 99%

Categories

(Tree Management :: Treeherder: Infrastructure, defect, P2)

Product:
Tree Management
Component:
Treeherder: Infrastructure
Type:
defect

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: emorley, Assigned: emorley)

References

(Blocks 1 open bug)

Details

In bug 1126943 the data lifecycle of the objectstore was reduced from 120 days (for prod; 45 days for stage) to 1 day. We should OPTIMIZE the objectstore tables to see the disk space and perf benefits.
Depends on: 1163591
Before: $ du -bc *objectstore* -ch | tail -n 1 38G total $ du -hs *objectstore* 180K accessibility_objectstore_1 19M addon_sdk_objectstore_1 30M alder_objectstore_1 125M ash_objectstore_1 2.4G b2g_inbound_objectstore_1 180K birch_objectstore_1 180K bmo_objectstore_1 180K bugzilla_objectstore_1 180K build_system_objectstore_1 241M cedar_objectstore_1 49M comm_aurora_objectstore_1 17M comm_beta_objectstore_1 57M comm_central_objectstore_1 180K comm_esr24_objectstore_1 19M comm_esr31_objectstore_1 180K comm_esr38_objectstore_1 257M cypress_objectstore_1 21M date_objectstore_1 19M elm_objectstore_1 5.1M fig_objectstore_1 4.0G fx_team_objectstore_1 180K gaia_master_objectstore_1 180K gaia_objectstore_1 957M gaia_try_objectstore_1 180K gaia_v1_4_objectstore_1 180K graphics_objectstore_1 105M gum_objectstore_1 30M holly_objectstore_1 20M jamun_objectstore_1 21M larch_objectstore_1 157M maple_objectstore_1 1.2G mozilla_aurora_objectstore_1 180K mozilla_b2g18_objectstore_1 180K mozilla_b2g18_v1_1_0_hd_objectstore_1 180K mozilla_b2g26_v1_2_objectstore_1 532K mozilla_b2g28_v1_3_objectstore_1 4.1M mozilla_b2g28_v1_3t_objectstore_1 145M mozilla_b2g30_v1_4_objectstore_1 205M mozilla_b2g32_v2_0_objectstore_1 281M mozilla_b2g34_v2_1_objectstore_1 69M mozilla_b2g34_v2_1s_objectstore_1 425M mozilla_b2g37_v2_2_objectstore_1 633M mozilla_beta_objectstore_1 2.0G mozilla_central_objectstore_1 180K mozilla_esr17_objectstore_1 15M mozilla_esr24_objectstore_1 173M mozilla_esr31_objectstore_1 17M mozilla_esr38_objectstore_1 12G mozilla_inbound_objectstore_1 161M mozilla_release_objectstore_1 157M oak_objectstore_1 17M pine_objectstore_1 180K qa_try_objectstore_1 180K services_central_objectstore_1 180K staging_gaia_try_objectstore_1 180K taskcluster_integration_objectstore_1 180K thunderbird_aurora_objectstore_1 180K thunderbird_beta_objectstore_1 180K thunderbird_esr24_objectstore_1 180K thunderbird_trunk_objectstore_1 180K thunderbird_try_objectstore_1 45M try_comm_central_objectstore_1 12G try_objectstore_1 180K try_taskcluster_objectstore_1 180K unknown_objectstore_1 180K ux_objectstore_1
Depends on: 1164824
After: $ du -bc *objectstore* -ch | tail -n 1 600M total Saving 37GB. I also performed the same on stage.
Status: ASSIGNED → RESOLVED
Closed: 10 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.