[Wikidata-bugs] [Maniphest] [Commented On] T169336: slow master queries on Wikibase\Client\Usage\Sql\EntityUsageTable::getAffectedRowIds

[jcrespo]

jcrespo added a comment.

I've setup a temporary watchdog on the s5 master:

pt-kill F=/dev/null --socket=/tmp/mysql.sock --print --kill --victims=all --match-info="EntityUsageTable" --match-db=wikidatawiki --match-user=wikiuser  --busy-time=1

This will mitigate for now the close-to-30 minute queries that were still happening on the master.

TASK DETAIL

https://phabricator.wikimedia.org/T169336

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Ladsgroup, jcrespo
Cc: Lydia_Pintscher, gerritbot, matej_suchanek, daniel, Ladsgroup, Aklapper, jcrespo, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Marostegui, Vali.matei, Lewizho99, Minhnv-2809, Maathavan, Volker_E, Izno, Luke081515, Wikidata-bugs, aude, GWicke, Mbch331, Jay8g, Krenair

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs