[02:07:03] <wikibugs>	 10DBA, 10Growth-Team, 10Notifications, 10Schema-change: Remove etp_user from echo_target_page in production - https://phabricator.wikimedia.org/T217453 (10Zoranzoki21)
[06:01:55] <wikibugs>	 10DBA, 10Growth-Team, 10Notifications, 10Schema-change: Remove etp_user from echo_target_page in production - https://phabricator.wikimedia.org/T217453 (10Marostegui) @Catrope this is ready to go anytime?
[16:47:20] <wikibugs>	 10DBA, 10Growth-Team, 10Notifications, 10Schema-change: Remove etp_user from echo_target_page in production - https://phabricator.wikimedia.org/T217453 (10Marostegui) If this schema change is ready to go, it would be great if we could get the task following the template described at https://wikitech.wikime...
[17:18:51] <wikibugs>	 10DBA, 10AbuseFilter: Slow queries on abuse_filter_log using afl_action or afl_actions - https://phabricator.wikimedia.org/T217481 (10Marostegui) From a quick look at it: That `SELECT * from abuse_filter_log`  is basically going thru the the whole table. Also, using `LIKE %FOO%` would make any index useless. L...
[17:24:10] <wikibugs>	 10DBA, 10AbuseFilter: Slow queries on abuse_filter_log using afl_action or afl_actions - https://phabricator.wikimedia.org/T217481 (10Daimona) @Marostegui Thanks! So that's because indexes are ignored with LIKE clauses starting with a wildcard, is it correct? Unfortunately the EXPLAIN on my local wiki doesn't...
[17:26:26] <wikibugs>	 10DBA, 10AbuseFilter: Slow queries on abuse_filter_log using afl_action or afl_actions - https://phabricator.wikimedia.org/T217481 (10Marostegui) Yes, they get ignored. Can't you run the new queries on labs?
[17:30:25] <wikibugs>	 10DBA, 10AbuseFilter: Slow queries on abuse_filter_log using afl_action or afl_actions - https://phabricator.wikimedia.org/T217481 (10Daimona) >>! In T217481#4995625, @Marostegui wrote: > Can't you run the new queries on labs?  Nope, since a few days. If I SSH to deployment-deploy01.eqiad.wmflabs and run `sql...
[17:38:57] <wikibugs>	 10DBA, 10AbuseFilter: Slow queries on abuse_filter_log using afl_action or afl_actions - https://phabricator.wikimedia.org/T217481 (10Marostegui) No, I meant the wiki replicas: https://wikitech.wikimedia.org/wiki/Portal:Data_Services#Wiki_Replicas (essentially quarry but from the command line). However, we do...
[17:45:44] <wikibugs>	 10DBA, 10AbuseFilter: Slow queries on abuse_filter_log using afl_action or afl_actions - https://phabricator.wikimedia.org/T217481 (10Daimona) >>! In T217481#4995638, @Marostegui wrote: > No, I meant the wiki replicas: https://wikitech.wikimedia.org/wiki/Portal:Data_Services#Wiki_Replicas (essentially quarry b...