Last Comment Bug 538313 - Run sql to update indexes on reports partition tables
: Run sql to update indexes on reports partition tables
01/26/2010 @ 7pm
Product: Graveyard
Classification: Graveyard
Component: Server Operations (show other bugs)
: other
: All Other
-- major (vote)
: ---
Assigned To: Aravind Gottipati [:aravind]
: matthew zeier [:mrz]
Depends on:
Blocks: 411354 538261
  Show dependency treegraph
Reported: 2010-01-06 17:15 PST by Frank Griswold [:griswolf] [:fgriswold]
Modified: 2015-03-12 08:17 PDT (History)
4 users (show)
mzeier: needs‑downtime+
See Also:
QA Whiteboard:
Iteration: ---
Points: ---


Description User image Frank Griswold [:griswolf] [:fgriswold] 2010-01-06 17:15:53 PST
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.
Comment 1 User image Frank Griswold [:griswolf] [:fgriswold] 2010-01-07 00:09:09 PST
Per IRC query from Fox2Mike: This needs to run on stage asap and go into production with the socorro 1.3 rollout.
Comment 2 User image Aravind Gottipati [:aravind] 2010-01-26 17:03:33 PST
Done on both staging and prod.

Note You need to log in before you can comment on or make changes to this bug.