[01:03:59] <wikibugs>	 10DBA, 10Operations, 10Wikimedia-Site-requests: Global rename of Idh0854 → Garam: supervision needed - https://phabricator.wikimedia.org/T167031#3356453 (10alanajjar) T168109
[02:11:06] <wikibugs>	 10DBA, 10Collaboration-Team-Triage, 10Notifications, 10Schema-change: Review new Echo table - https://phabricator.wikimedia.org/T168107#3356374 (10Mattflaschen-WMF) Please hold off on this temporarily.  I agree with TTO at https://gerrit.wikimedia.org/r/#/c/350500/3/db_patches/echo_user_group_notifications...
[02:15:22] <wikibugs>	 10DBA, 10Collaboration-Team-Triage, 10Notifications, 10Schema-change: Review new Echo table for user group expiration - https://phabricator.wikimedia.org/T168107#3356499 (10Mattflaschen-WMF)
[02:27:51] <wikibugs>	 10DBA, 10Collaboration-Team-Triage, 10Notifications, 10Schema-change: Review new Echo table for user group expiration - https://phabricator.wikimedia.org/T168107#3356503 (10Mattflaschen-WMF)
[05:01:51] <wikibugs>	 10DBA, 10Collaboration-Team-Triage, 10Notifications, 10Schema-change: Review new Echo table for user group expiration - https://phabricator.wikimedia.org/T168107#3356529 (10Marostegui) 05Open>03stalled p:05Triage>03Normal
[05:06:43] <wikibugs>	 10DBA, 10Operations, 10Wikimedia-Site-requests: Global rename of Smuconlaw → Sgconlaw: supervision needed - https://phabricator.wikimedia.org/T168109#3356544 (10Marostegui) p:05Triage>03Normal Please ping me before doing this (either here or on IRC) so I can monitor the databases while this is being perf...
[10:52:50] <wikibugs>	 10DBA, 10Operations, 10Wikimedia-Site-requests: Global rename of Smuconlaw → Sgconlaw: supervision needed - https://phabricator.wikimedia.org/T168109#3356440 (10Framawiki) Please use `per [[:meta:Special:GlobalRenameQueue/request/33965/view|request]] - [[phab:T168109|task]]` in the edit summary, I declined t...
[17:00:32] <Cyberpower678>	 Reedy_: volans: I could really use some help trying to understand how the DB handles INDEXes.
[17:00:34] <Cyberpower678>	 EXPLAIN SELECT * FROM externallinks_global FORCE INDEX (APIINDEX1,APIINDEX2,APIINDEX3,APIINDEX4,APIINDEX5,APIINDEX6,APIINDEX7,APIINDEX8) LEFT JOIN externallinks_paywall ON externallinks_global.paywall_id=externallinks_paywall.paywall_id WHERE ( `live_state` IN (0, 7) OR externallinks_global.paywall_id IN (SELECT paywall_id FROM externallinks_paywall WHERE `paywall_status` IN (3)) ) AND `reviewed` = 0 LIMIT 10000
[17:00:34] <Cyberpower678>	 0,1001;
[17:00:49] <Cyberpower678>	 But none of those indexes actually take in the query.
[17:01:51] <Cyberpower678>	 After working long and hard, I think this general query will optimize performance and get what I need, provided the indexes I setup are used.  What am I doing wrong?  I feel rather useless/helpless now.
[17:22:51] <Cyberpower678>	 legoktm: I need a sysadmin.
[17:23:02] <Cyberpower678>	 I would like to rename an account with 75k edits.