schema change: add index usr_col_mod_idx (username, collection, modified)

RESOLVED FIXED

Status

Cloud Services
Server: Sync
RESOLVED FIXED
7 years ago
7 years ago

People

(Reporter: atoll, Assigned: telliott)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

(Whiteboard: [php][py=663474][deployed to production])

(Reporter)

Description

7 years ago
Please update the wbo table schema to add a new index:

usr_col_mod_idx (username, collection, modified)
(Reporter)

Updated

7 years ago
Whiteboard: [php][py=][deployed to production] → [php][py=663474][deployed to production]
Toby, do you maintain a copy of this in code anywhere? I updated our copy that we use to bootstrap new databases.
We should keep a copy of the DB schema in a single place - I added bug 663626 for this
(Assignee)

Comment 3

7 years ago
You mean this specification?

http://hg.mozilla.org/services/sync-server/file/4df296e0880e/1.1/weave_storage/mysql.php#l56

seems like the logical place to have kept the schema. Note that this one has the missing index, and has for, well, a long time.
(Assignee)

Comment 4

7 years ago
php is dead.
Status: NEW → RESOLVED
Last Resolved: 7 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.