[06:21:13] <wikibugs>	 10DBA, 10Analytics, 10Analytics-EventLogging: db1047 has been restarted - needs another restart - https://phabricator.wikimedia.org/T166452#3296553 (10Marostegui)
[06:35:54] <wikibugs>	 10DBA, 10Analytics, 10Analytics-EventLogging: db1047 has been restarted - needs another restart - https://phabricator.wikimedia.org/T166452#3296592 (10Marostegui) This is the reason why it is not able cope with the pt-table-checksum on s1:  On revision table: ```   PRIMARY KEY (`rev_page`,`rev_id`), ```  On...
[16:40:04] <Cyberpower678>	 volans: I have a question for a DB expert
[16:40:23] <Cyberpower678>	 I'm running the query "SELECT * FROM externallinks_global LEFT JOIN externallinks_paywall ON externallinks_global.paywall_id=externallinks_paywall.paywall_id WHERE `has_archive` = 1 AND ( `live_state` IN (6) OR paywall_status IN (2) ) LIMIT 1000,1001"
[16:40:57] <Cyberpower678>	 It's taking an excrutiating long time to run despite all the columns in the WHERE clause being indexed.  Any way to speed it up?
[17:21:10] <Reedy>	 What does EXPLAIN say?
[19:54:47] <Cyberpower678>	 Reedy: I've never used explain.  My SQL knowledge is only enough to get it to work.
[19:55:00] <Cyberpower678>	 Needless to say I don't understand it.