[Wikidata-bugs] [Maniphest] [Commented On] T225500: Decrease EntityUsageTable addUsage batch size to 100

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2019-06-26T12:06:36Z] Synchronized wmf-config/InitialiseSettings.php: SWAT: [[gerrit:518952|Set EntityUsageTable addUsage batch size to 100 (T225500 )]] (duration: 00m 56s) TASK D

[Wikidata-bugs] [Maniphest] [Commented On] T225500: Decrease EntityUsageTable addUsage batch size to 100

gerritbot added a comment. Change 518952 **merged** by jenkins-bot: [operations/mediawiki-config@master] Set EntityUsageTable addUsage batch size to 100 https://gerrit.wikimedia.org/r/518952 TASK DETAIL https://phabricator.wikimedia.org/T225500 EMAIL PREFERENCES https://phabricato

[Wikidata-bugs] [Maniphest] [Commented On] T225500: Decrease EntityUsageTable addUsage batch size to 100

Ladsgroup added a comment. In T225500#5285814 , @Lucas_Werkmeister_WMDE wrote: > In T225500#5249527 , @Michael wrote: > > > The plan is to remove it to 100 in steps of 200, 150, 100.

[Wikidata-bugs] [Maniphest] [Commented On] T225500: Decrease EntityUsageTable addUsage batch size to 100

Lucas_Werkmeister_WMDE added a comment. In T225500#5249527 , @Michael wrote: > The plan is to remove it to 100 in steps of 200, 150, 100. > > While doing that, we have to watch https://grafana.wikimedia.org/d/00273/mysql?orgId=1

[Wikidata-bugs] [Maniphest] [Commented On] T225500: Decrease EntityUsageTable addUsage batch size to 100

gerritbot added a comment. Change 518952 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [operations/mediawiki-config@master] Set EntityUsageTable addUsage batch size to 100 https://gerrit.wikimedia.org/r/518952 TASK DETAIL https://phabricator.wikimedia.org/T22550

[Wikidata-bugs] [Maniphest] [Commented On] T225500: Decrease EntityUsageTable addUsage batch size to 100

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2019-06-20T14:22:48Z] Synchronized wmf-config/InitialiseSettings.php: SWAT: [[gerrit:517669|Set EntityUsageTable addUsage batch size to 150 (T225500 )]] (duration: 00m 56s) TASK D

[Wikidata-bugs] [Maniphest] [Commented On] T225500: Decrease EntityUsageTable addUsage batch size to 100

gerritbot added a comment. Change 517669 **merged** by jenkins-bot: [operations/mediawiki-config@master] Set EntityUsageTable addUsage batch size to 150 https://gerrit.wikimedia.org/r/517669 TASK DETAIL https://phabricator.wikimedia.org/T225500 EMAIL PREFERENCES https://phabricato

[Wikidata-bugs] [Maniphest] [Commented On] T225500: Decrease EntityUsageTable addUsage batch size to 100

alaa_wmde added a comment. This should happen in a SWAT right? (can't find it scheduled though) TASK DETAIL https://phabricator.wikimedia.org/T225500 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Michael, alaa_wmde Cc: alaa_wmde, Aklapper, Micha

[Wikidata-bugs] [Maniphest] [Commented On] T225500: Decrease EntityUsageTable addUsage batch size to 100

gerritbot added a comment. Change 517669 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [operations/mediawiki-config@master] Set EntityUsageTable addUsage batch size to 150 https://gerrit.wikimedia.org/r/517669 TASK DETAIL https://phabricator.wikimedia.org/T22550

[Wikidata-bugs] [Maniphest] [Commented On] T225500: Decrease EntityUsageTable addUsage batch size to 100

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2019-06-17T11:49:21Z] Synchronized wmf-config/InitialiseSettings.php: SWAT: [[gerrit|516478 Set EntityUsageTable addUsage batch size to 200 (T225500 )]] (duration: 00m 47s) TASK D

[Wikidata-bugs] [Maniphest] [Commented On] T225500: Decrease EntityUsageTable addUsage batch size to 100

gerritbot added a comment. Change 516478 **merged** by jenkins-bot: [operations/mediawiki-config@master] Set EntityUsageTable addUsage batch size to 200 https://gerrit.wikimedia.org/r/516478 TASK DETAIL https://phabricator.wikimedia.org/T225500 EMAIL PREFERENCES https://phabricato

[Wikidata-bugs] [Maniphest] [Commented On] T225500: Decrease EntityUsageTable addUsage batch size to 100

Michael added a comment. The plan is to remove it to 100 in steps of 200, 150, 100. While doing that, we have to watch https://grafana.wikimedia.org/d/00273/mysql?orgId=1 especially the "Queries per second" number. That number is 13.77K right now. A DBA should be aware of these

[Wikidata-bugs] [Maniphest] [Commented On] T225500: Decrease EntityUsageTable addUsage batch size to 100

gerritbot added a comment. Change 516478 had a related patch set uploaded (by Michael Große; owner: Michael Große): [operations/mediawiki-config@master] Set EntityUsageTable addUsage batch size to 100 https://gerrit.wikimedia.org/r/516478 TASK DETAIL https://phabricator.wikimedia.or