Once the local_user_id and global_user_id fields are completely populated on the production cluster, we should get the DBAs to add the following indexes:
- (lu_local_id, lu_wiki)
- (lu_global_id, lu_wiki)
These should not be UNIQUE.
Once the local_user_id and global_user_id fields are completely populated on the production cluster, we should get the DBAs to add the following indexes:
These should not be UNIQUE.
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Open | Feature | None | T66475 Make crosswiki bits and pieces truly global (tracking) | ||
Open | Feature | None | T5525 Cross-wiki watchlists | ||
Open | None | T148243 Add indices for local_user_id and global_user_id in production | |||
Resolved | Niharika | T148242 Fully populate local_user_id and global_user_id fields in production | |||
Resolved | Niharika | T142503 Create a maintenance script for populating the local_user_id and global_user_id fields in the centralauth localuser table | |||
Resolved | Marostegui | T141951 Add local_user_id and global_user_id fields to localuser table in centralauth database | |||
Resolved | Johan | T150835 Notify stewards and global renamers about T148242 |
Hi,
Thanks for the ticket. We (DBAs) are not completely sure about how to proceed on this ticket as we are missing some information.
In order to avoid misunderstandings would you be so kind to follow this procedure, as it makes sure we have all the information we'd need to proceed with the ticket?
https://www.mediawiki.org/wiki/Development_policy#Deploying_to_production
https://wikitech.wikimedia.org/wiki/Schema_changes
Of course, if you need more information or help from us, let us know in this ticket and we'll happily help!
Thanks
Hi @Marostegui we're not proceeding with this task until code that needs these indices is in places. Taking off the DBA tag for now.
Thank you!
Hey @Niharika - thanks for the heads up!
Let us know when you need us then :-)
Manuel.