Yeah, that should arrive to normal replicas now.

I tried a few versions of the query and it seems to perform very well, under a second I think. Something like:

# preparation
>>> $revQuery = mws()->getRevisionStore()->getQueryInfo( [ 'page' ] ); $revQuery['joins']['revision'] = $revQuery['joins']['page']; unset( $revQuery['joins']['page'] ); $revQuery['tables'] = array_merge( [ 'page' ], array_diff( $revQuery['tables'], [ 'page' ] ) );
# content language, default group
>>> wfGetDB(DB_REPLICA)->select( $revQuery['tables'], $revQuery['fields'], [ 'page_is_redirect' => 0, 'page_namespace' => 8, 'page_title NOT LIKE "%/%"', 'page_len <= 1024', 'page_latest = rev_id' ], 'lucas-test-T314493', [ 'STRAIGHT_JOIN' ], $revQuery['joins'] )
# /de, vslow
>>> wfGetDB(DB_REPLICA, ['vslow'])->select( $revQuery['tables'], $revQuery['fields'], [ 'page_is_redirect' => 0, 'page_namespace' => 8, 'page_title LIKE "%/de"', 'page_len <= 1024', 'page_latest = rev_id' ], 'lucas-test-T314493', [ 'STRAIGHT_JOIN' ], $revQuery['joins'] )

Change 820150 had a related patch set uploaded (by Lucas Werkmeister (WMDE); author: Lucas Werkmeister (WMDE)):

[mediawiki/core@master] Revert "MessageCache: Avoid 'contributions' replicas"

https://gerrit.wikimedia.org/r/820150

@Lucas_Werkmeister_WMDE Which wikis was that on? The original task was about enwiki but it's worth checking metawiki (and commonswiki) as well, those would likely be more sensitive the the issue I suspect.

Change 820150 merged by jenkins-bot:

[mediawiki/core@master] Revert "MessageCache: Avoid 'contributions' replicas"

https://gerrit.wikimedia.org/r/820150

I tested enwiki and commonswiki yesterday; I’ve now checked metawiki as well and performance still seems fine for all four groups (none, api, vslow, dump) and both unsuffixed and /de pages (though one of the queries, unsuffixed on dump, was closer to two seconds than one second).