[09:28:17] 10DBA, 10MediaWiki-API, 07Performance: action=query&list=pagepropnames really slow on a big wiki, got error with ppnlimit=500 - https://phabricator.wikimedia.org/T115825#1733673 (10Dalba) Pywikibot (T163635) has a similar problem with the following API query on Wikidata. * https://www.wikidata.org/w/api.php... [17:34:55] 10DBA, 10AbuseFilter, 06Performance-Team, 13Patch-For-Review: AFComputedVariable::compute query timeouts - https://phabricator.wikimedia.org/T116557#3204426 (10jcrespo) ``` root@db2062[enwiki]> ANALYZE TABLE revision; +-----------------+---------... [18:03:05] 10DBA, 10AbuseFilter, 06Performance-Team, 13Patch-For-Review: AFComputedVariable::compute query timeouts - https://phabricator.wikimedia.org/T116557#3204493 (10jcrespo) Nope, it doesn't work either: ``` root@db2062[enwiki]> SELECT version(); +-----------------+ | version() | +-----------------+ | 10.... [18:04:05] 10DBA, 10AbuseFilter, 06Performance-Team, 13Patch-For-Review: AFComputedVariable::compute query timeouts - https://phabricator.wikimedia.org/T116557#3204495 (10jcrespo) CC @Anomie because I think he was hoping 10.1 would solve this or very similar issues, but it doesn't seem to be the case. :-/ [18:09:21] 10DBA, 07Availability: Look into Maria 10 parallel-replication - https://phabricator.wikimedia.org/T85266#3204510 (10jcrespo) db2062 now has as a test MariaDB 10.1, which has enabled by default conservative parallel replication- we will see how stable and reliable (data wise) that is, and it it really helps in...