Legoktm created this task.
Legoktm added projects: Wikidata, Datacenter-Switchover, DBA.
Restricted Application added a subscriber: Aklapper.
Restricted Application added a project: wdwb-tech.
TASK DESCRIPTION
s8 was struggling today after the DC switchover, and it was suggested that we
add some URLs to the cache warmup for Wikidata.
(log trimmed)
07:53:09 <_joe_> marostegui: do we have dbs suffering?
07:53:15 <@marostegui> yes, s8
07:54:08 <Amir1> (once this is all done): marostegui let's talk about if
there is anything on wikibase side is needed
07:56:06 <jynus> is it
Wikibase\Lib\Store\Sql\Terms\DatabaseTermInLangIdsResolver::selectTermsViaJoin ?
07:56:34 <Amir1> that's termstore replacement
07:56:42 <Amir1> I think because cache is cold
07:56:48 <Amir1> (memcached for term store)
07:56:52 <jynus> mine it is just a guess because it is the only query I am
seeing
07:57:04 <jynus> on the heavy hit servers
07:57:34 <Amir1> maybe for the next dc switch we should "warm it up"
beforehand
07:57:41 <_joe_> Amir1: yes definitely
07:57:50 <jynus> I see a few fetchterms too
07:57:51 <@legoktm> we can add some Wikidata URLs to the warmup
07:58:03 <@marostegui> legoktm: that'd be nice indeed
07:58:20 <Amir1> legoktm: it's a common misconception: most of reads on s8
are not coming from wikidata.org
07:58:30 <Amir1> this needs some parsing
07:59:17 <@legoktm> Amir1: "URLs that warmup the relevant Wikidata paths :)"
07:59:25 <Amir1> better :D
The URLs that are currently hit as part of the warmup process are located at
https://gerrit.wikimedia.org/g/operations/puppet/+/545b517cea678d8fdeadeb6051e0f3757bd4ebff/modules/mediawiki/files/maintenance/mediawiki-cache-warmup/
TASK DETAIL
https://phabricator.wikimedia.org/T290989
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Legoktm
Cc: jcrespo, Marostegui, Lucas_Werkmeister_WMDE, Ladsgroup, Legoktm, Aklapper,
Invadibot, Devnull, LSobanski, maantietaja, Akuckartz, Iflorez, RhinosF1,
Nandana, jijiki, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer,
Minhnv-2809, Volans, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude,
Addshore, Mbch331, Jay8g, Krenair, akosiaris
_______________________________________________
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org
