[Wikidata-bugs] [Maniphest] [Updated] T107319: [Bug] EntityUsageTable::touchUsages slow query
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, Aklapper, aude, Wikidata-bugs, GWicke ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Updated] T107319: [Bug] EntityUsageTable::touchUsages slow query
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 ('2430363','2430361','2430345','2430360','2430348','61591','61590','107383','2430347','2430358','2430343','2430362','2430365','2430351','2430353','2430354','2430344','2430356','2430350','2430366','2430355','2430359','2430352','2430357','2430346','2430349','2430364') Created a new task for this: https://phabricator.wikimedia.org/T111769 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, Aklapper, aude, Wikidata-bugs, GWicke ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Updated] T107319: [Bug] EntityUsageTable::touchUsages slow query
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, aude, Wikidata-bugs, GWicke, Krenair, Malyacko ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Updated] T107319: [Bug] EntityUsageTable::touchUsages slow query
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, aude, Wikidata-bugs, Malyacko ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Updated] T107319: [Bug] EntityUsageTable::touchUsages slow query
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, Malyacko ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Updated] T107319: [Bug] EntityUsageTable::touchUsages slow query
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 https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: aude Cc: JanZerebecki, daniel, hoo, Addshore, Lydia_Pintscher, ori, jcrespo, Aklapper, aude, Wikidata-bugs, Malyacko ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs