[05:08:21] 10Phabricator, 07Performance: Phabricator search results take a long time to execute - https://phabricator.wikimedia.org/T146562#2666115 (10Pine) Thanks for confirming that searches are taking a very long time. It seems to me that search results should appear in about 3 seconds max, not 37 to 69 seconds. What... [09:05:08] 10Phabricator, 07Performance: Phabricator search results take a long time to execute - https://phabricator.wikimedia.org/T146562#2666385 (10Aklapper) From the top of my head: * Anyone could add recommendations to use more specialized search queries (e.g. search by product / using a narrower scope in the dropdo... [09:09:46] 10Phabricator: remove user @AniaMag - https://phabricator.wikimedia.org/T146549#2666387 (10Aklapper) p:05Triage>03Low [13:29:54] 10Phabricator: remove user @AniaMag - https://phabricator.wikimedia.org/T146549#2666987 (10Aklapper) a:03Aklapper [17:06:06] 10Phabricator, 06Release-Engineering-Team: Contention on search phabricator database creating full phabricator outages - https://phabricator.wikimedia.org/T146673#2667974 (10jcrespo) [17:07:01] 10Phabricator, 06Release-Engineering-Team: Contention on search phabricator database creating full phabricator outages - https://phabricator.wikimedia.org/T146673#2667988 (10jcrespo) [17:13:37] 10Phabricator, 06Release-Engineering-Team: Contention on search phabricator database creating full phabricator outages - https://phabricator.wikimedia.org/T146673#2668002 (10jcrespo) In particular see how after converting the table, all table locking issues get converted into row locking instances which will b... [17:14:45] 10Phabricator, 06Release-Engineering-Team: Contention on search phabricator database creating full phabricator outages - https://phabricator.wikimedia.org/T146673#2668011 (10jcrespo) Also, re indexing is still in progress: https://grafana-admin.wikimedia.org/dashboard/db/mysql?panelId=2&fullscreen&from=1474886... [17:32:24] 10Phabricator, 06Release-Engineering-Team: Contention on search phabricator database creating full phabricator outages - https://phabricator.wikimedia.org/T146673#2668118 (10mmodell) We previously abandoned elasticsearch for phabricator. It might be time to look into that again. [17:33:41] 10Phabricator, 06Release-Engineering-Team: Contention on search phabricator database creating full phabricator outages - https://phabricator.wikimedia.org/T146673#2668122 (10mmodell) p:05Triage>03High [17:37:24] 10Phabricator, 06Release-Engineering-Team: Contention on search phabricator database creating full phabricator outages - https://phabricator.wikimedia.org/T146673#2668131 (10mmodell) Someone asked upstream about why the table isn't innodb and epriestley [[ https://secure.phabricator.com/T4130#65039 | responded... [18:11:41] 10Phabricator, 06Release-Engineering-Team: Contention on search phabricator database creating full phabricator outages - https://phabricator.wikimedia.org/T146673#2668203 (10mmodell) It looks like innodb does not support stemming, among other limitations. [18:13:46] 10Phabricator, 06Release-Engineering-Team: Contention on search phabricator database creating full phabricator outages - https://phabricator.wikimedia.org/T146673#2668206 (10Paladox) @mmodell is stemming a full text search if so MySQL 5.6 or 5.7+ support full text searches. Also mariadb supports full search i... [21:02:14] 10Phabricator, 06Wikipedia-iOS-App-Backlog, 10iOS-app-feature-Accessibility, 10iOS-app-feature-Multilingual: Herald rule requests for iOS - https://phabricator.wikimedia.org/T146701#2668818 (10Josve05a) [21:02:44] 10Phabricator, 06Wikipedia-iOS-App-Backlog, 10iOS-app-feature-Accessibility, 10iOS-app-feature-Multilingual: Herald rule requests for iOS - https://phabricator.wikimedia.org/T146701#2668831 (10Josve05a) [21:04:40] 10Phabricator, 06Wikipedia-iOS-App-Backlog, 10iOS-app-feature-Accessibility, 10iOS-app-feature-Multilingual: Herald rule requests for iOS - https://phabricator.wikimedia.org/T146701#2668818 (10MBinder_WMF) Note: I can make this (I think) but have Herald permissions to manage existing rules, not necessarily... [21:06:49] 10Phabricator, 06Wikipedia-iOS-App-Backlog, 10iOS-app-feature-Accessibility, 10iOS-app-feature-Multilingual: Herald rule requests for iOS - https://phabricator.wikimedia.org/T146701#2668857 (10Josve05a) [21:13:45] 10Phabricator, 06Wikipedia-iOS-App-Backlog, 10iOS-app-feature-Accessibility, 10iOS-app-feature-Multilingual: Herald rule requests for iOS - https://phabricator.wikimedia.org/T146701#2668868 (10Josve05a) [21:14:00] 10Phabricator, 06Wikipedia-iOS-App-Backlog, 10iOS-app-feature-Accessibility, 10iOS-app-feature-Multilingual, 10iOS-app-feature-WP0: Herald rule requests for iOS - https://phabricator.wikimedia.org/T146701#2668818 (10Josve05a)