Ladsgroup added a comment.
What we have done here:
We went through the performance schema of replicas in codfw since the
switchover (September 2, 17 days ago) to see what is the nature of queries
going to replicas. Total latency of selects for s8 replicas is 57712491 seconds
(roughly 100 weeks). The load broken down by the nature of the query is this:
term_store: 56.38%
rest_of_wikibase: 6.63%
rc: 0.24%
revision: 22.36%
The rest of mediawiki: 9.08%
outside mediawiki: 5.31%
This can be further broken down, let us know if you want to more, like what
are the top resource-consuming queries or what is "the rest of mediawiki", ...
We also put up a patch that adds statsd metrics for the term store, to see
how much of the pressure on s8 is coming from clients or replicas.
TASK DETAIL
https://phabricator.wikimedia.org/T246415
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Ladsgroup
Cc: Marostegui, Ladsgroup, WMDE-leszek, Aklapper, Addshore, Alter-paule,
Beast1978, Un1tY, Akuckartz, Hook696, Iflorez, darthmon_wmde, Kent7301,
alaa_wmde, joker88john, CucyNoiD, Nandana, jijiki, Klaas_Z4us_V, Gaboe420,
Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, Bsandipan, Pablo-WMDE,
GoranSMilovanovic, QZanden, LawExplorer, Lewizho99, Maathavan, elukey, _jensen,
rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331,
Jay8g
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
