Run sql to update indexes on reports partition tables

RESOLVED FIXED

Status

mozilla.org Graveyard
Server Operations
--
major
RESOLVED FIXED
8 years ago
2 years ago

People

(Reporter: griswolf, Assigned: aravind)

Tracking

Dependency tree / graph
Bug Flags:
needs-downtime +

Details

(Whiteboard: 01/26/2010 @ 7pm)

See script "Drop and create some indexes on existing reports partitions" attached to bug 411354

This script would require approximately 3 hours to run on khan connected to dm_breakpad_stagedb: You will need to adjust your expectations for the production database.

Although these indexes are not required for the Socorro 1.3 rollout on 2009-01-07, they will increase efficiency for queries that look at the build column in reports table. 

All but the 'current' and one or two immediately prior partitions could be indexed without causing much if any difficulty on a running system, so if you wish to pay attention, you could do just a few while off line, and do the others soon thereafter.
Blocks: 411354
Blocks: 538261
Per IRC query from Fox2Mike: This needs to run on stage asap and go into production with the socorro 1.3 rollout.

Updated

8 years ago
Assignee: server-ops → jeremy.orem+bugs

Updated

8 years ago
Assignee: jeremy.orem+bugs → aravind
Flags: needs-downtime+
Group: infra
Whiteboard: 01/26/2010 @ 7pm
(Assignee)

Comment 2

8 years ago
Done on both staging and prod.
Status: NEW → RESOLVED
Last Resolved: 8 years ago
Resolution: --- → FIXED
Product: mozilla.org → mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.