Please update the wbo table schema to add a new index: usr_col_mod_idx (username, collection, modified)
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
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.
php is dead.
Status: NEW → RESOLVED
Last Resolved: 8 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.