Closed Bug 912482 Opened 11 years ago Closed 11 years ago

Change addons_mozilla_org.addons indexes

Categories

(Marketplace Graveyard :: Code Quality, defect, P2)

Product:
Marketplace Graveyard
Component:
Code Quality
Version:
Avenir
Platform:
x86
macOS
Type:
defect

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: scabral, Assigned: ashort)

References

Details

(Whiteboard: [qa-]) 

As per https://bugzilla.mozilla.org/show_bug.cgi?id=862889#c4:

Recommendation - can be done in real time since adding/removing indexes are non-blocking:
Eliminate duplicate index on name and add index on (name,status,addontype_id):

alter table addons_mozilla_org.addons add index(name,status,addontype_id), drop index addons_ibfk_2;

Note - even if you do not add the index, there is no reason for the index on name, since there is already a UNIQUE index on name.

And of course, we recommend doing on dev/stage first, then production.
Blocks: 912484
No longer blocks: 912484
Marketplace devs: please create a migration for this request.
Assignee: server-ops-amo → nobody
Component: Server Operations: AMO Operations → Code Quality
Product: mozilla.org → Marketplace
QA Contact: oremj
Target Milestone: --- → 2013-10-01
Version: other → Avenir
Assignee: nobody → ashort
Priority: -- → P2
Target Milestone: 2013-10-01 → ---
https://github.com/mozilla/zamboni/commit/86fb7f7c
Status: NEW → RESOLVED
Closed: 11 years ago
Resolution: --- → FIXED
Whiteboard: [qa-]
You need to log in before you can comment on or make changes to this bug.