[Wikidata-bugs] [Maniphest] [Updated] T107319: [Bug] EntityUsageTable::touchUsages slow query

2015-09-08 Thread aude
aude removed a project: Patch-For-Review. TASK DETAIL https://phabricator.wikimedia.org/T107319 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: daniel, aude Cc: Krenair, gerritbot, JanZerebecki, daniel, hoo, Addshore, Lydia_Pintscher, ori, jcrespo,

[Wikidata-bugs] [Maniphest] [Updated] T107319: [Bug] EntityUsageTable::touchUsages slow query

2015-09-08 Thread aude
aude added a comment. I now see some slow queries in the logs for touch usages: UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsageBatch */ `wbc_entity_usage` SET eu_touched = '20150907064933' WHERE eu_row_id IN

[Wikidata-bugs] [Maniphest] [Updated] T107319: [Bug] EntityUsageTable::touchUsages slow query

2015-08-25 Thread daniel
daniel added projects: Performance, Database. TASK DETAIL https://phabricator.wikimedia.org/T107319 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: daniel Cc: gerritbot, JanZerebecki, daniel, hoo, Addshore, Lydia_Pintscher, ori, jcrespo, Aklapper,

[Wikidata-bugs] [Maniphest] [Updated] T107319: [Bug] EntityUsageTable::touchUsages slow query

2015-08-21 Thread gerritbot
gerritbot added a project: Patch-For-Review. TASK DETAIL https://phabricator.wikimedia.org/T107319 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: gerritbot Cc: gerritbot, JanZerebecki, daniel, hoo, Addshore, Lydia_Pintscher, ori, jcrespo, Aklapper,

[Wikidata-bugs] [Maniphest] [Updated] T107319: [Bug] EntityUsageTable::touchUsages slow query

2015-08-20 Thread aude
aude added a project: Wikidata-Sprint-2015-08-18. TASK DETAIL https://phabricator.wikimedia.org/T107319 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: aude Cc: JanZerebecki, daniel, hoo, Addshore, Lydia_Pintscher, ori, jcrespo, Aklapper, aude,

[Wikidata-bugs] [Maniphest] [Updated] T107319: [Bug] EntityUsageTable::touchUsages slow query

2015-08-18 Thread aude
aude added a comment. https://phabricator.wikimedia.org/T93885 will also help (have a specific limit for number of entities used in a page). we need to add a setting and then enforce the limit. TASK DETAIL https://phabricator.wikimedia.org/T107319 EMAIL PREFERENCES