Ladsgroup created this task. Ladsgroup added projects: Wikidata-Campsite (Wikidata-Campsite-Iteration-∞), Wikidata. Restricted Application added a subscriber: Aklapper.
TASK DESCRIPTION Graphs <https://grafana.wikimedia.org/d/000000548/wikibase-wb_terms?refresh=30s&orgId=1> show us that `PrefetchingPropertyTermLookup::prefetchTerms()` is being called around 70K times every minute. This is clearly too much for something like properties. I suggest adding a layer of APCu cache with TTL of ten seconds to keep the hot data in the servers for long period of time without drowning it. TASK DETAIL https://phabricator.wikimedia.org/T242871 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup Cc: Aklapper, WMDE-leszek, Jakob_WMDE, Addshore, Ladsgroup, Iflorez, darthmon_wmde, alaa_wmde, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
