Closed Bug 1163588 Opened 9 years ago Closed 9 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: 9 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.