jcrespo added a comment. And here it is actual data of an example spike:
Host User Schema Client Source Thread Transaction Runtime Stamp db1038 wikiuser simplewiki mw1001 - 5096510924 30A18B0D6 15s 2015-08-15 10:04:05 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20140130031809' WHERE eu_page_id = '232335' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser mwlwiki mw1006 - 5096510302 30A18AA42 14s 2015-08-15 10:03:55 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20130201200841' WHERE eu_page_id = '1' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser skwiki mw1009 - 5096509493 30A18A10F 13s 2015-08-15 10:03:35 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150218224016' WHERE eu_page_id = '1' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser elwiki mw1016 - 5096509480 30A18A0F7 13s 2015-08-15 10:03:35 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150427204519' WHERE eu_page_id = '260239' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser kawiki mw1015 - 5096509531 30A18A156 12s 2015-08-15 10:03:35 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150803200253' WHERE eu_page_id = '16312' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser guwiki mw1005 - 5096509757 30A18A40B 12s 2015-08-15 10:03:55 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150815100353' WHERE eu_page_id = '1' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser tlwiki mw1007 - 5096509558 30A18A19E 11s 2015-08-15 10:03:35 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20141113113613' WHERE eu_page_id = '1' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser simplewiki mw1012 - 5096509479 30A18A0F6 11s 2015-08-15 10:03:35 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150815100333' WHERE eu_page_id = '232335' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser bewiki mw1013 localhost 5096509524 30A18A14A 11s 2015-08-15 10:03:45 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages 127.0.0.1 */ `wbc_entity_usage` SET eu_touched = '20150815100343' WHERE eu_page_id = '50792' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser bnwiki mw1008 - 5096509501 30A18A11E 11s 2015-08-15 10:03:45 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150815100343' WHERE eu_page_id = '796' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser srwiki mw1008 localhost 5096509510 30A18A12D 9s 2015-08-15 10:03:45 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages 127.0.0.1 */ `wbc_entity_usage` SET eu_touched = '20150815100335' WHERE eu_page_id = '196554' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser sdwiki mw1014 - 5096509431 30A18A000 9s 2015-08-15 10:03:45 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150815100335' WHERE eu_page_id = '2238' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser hiwiki mw1013 - 5096510664 30A18AE18 9s 2015-08-15 10:04:05 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150520065035' WHERE eu_page_id = '220108' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser dawiki mw1008 - 5096510405 30A18AB5C 9s 2015-08-15 10:04:05 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150815100355' WHERE eu_page_id = '77' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser bnwiki mw1004 - 5096511317 30A18B4E0 9s 2015-08-15 10:04:15 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150811141738' WHERE eu_page_id = '796' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser sdwiki mw1011 - 5096509434 30A18A009 8s 2015-08-15 10:03:35 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150616152312' WHERE eu_page_id = '2238' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser hrwiki mw1002 - 5096509689 30A18A33B 8s 2015-08-15 10:03:45 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150328211552' WHERE eu_page_id = '4' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser liwiki mw1003 - 5096510879 30A18B05D 8s 2015-08-15 10:04:15 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150815100406' WHERE eu_page_id = '1' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser guwiki mw1007 - 5096509750 30A18A3E7 7s 2015-08-15 10:03:45 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150719055033' WHERE eu_page_id = '1' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser tlwiki mw1001 - 5096510816 30A18AFB4 7s 2015-08-15 10:04:05 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20141113113613' WHERE eu_page_id = '1' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser mrwiki mw1003 - 5096510809 30A18AFA7 7s 2015-08-15 10:04:05 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150815100357' WHERE eu_page_id = '2' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser tnwiki mw1006 - 5096510113 30A18A829 7s 2015-08-15 10:04:05 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150815100357' WHERE eu_page_id = '596' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser liwiki mw1003 - 5096510854 30A18B01D 6s 2015-08-15 10:04:05 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150302091823' WHERE eu_page_id = '1' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser hiwiki mw1015 - 5096524966 30A196449 6s 2015-08-15 10:14:45 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150520065035' WHERE eu_page_id = '220108' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser tnwiki mw1009 - 5096510155 30A18A889 5s 2015-08-15 10:03:55 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20140228020245' WHERE eu_page_id = '596' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser elwiki mw1015 - 5096511444 30A18B670 5s 2015-08-15 10:04:15 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150427204519' WHERE eu_page_id = '260239' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser hiwiki mw1016 - 5096510724 30A18AEBC 5s 2015-08-15 10:04:15 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150815100410' WHERE eu_page_id = '220108' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser dsbwiki mw1013 - 5096511261 30A18B44D 5s 2015-08-15 10:04:25 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150815100419' WHERE eu_page_id = '1' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser bewiki mw1002 - 5096509508 30A18A12B 3s 2015-08-15 10:03:35 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150124160624' WHERE eu_page_id = '50792' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser gawiki mw1002 - 5096509507 30A18A12A 3s 2015-08-15 10:03:35 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150803043836' WHERE eu_page_id = '19594' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser bnwiki mw1004 - 5096509488 30A18A106 3s 2015-08-15 10:03:35 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150811141738' WHERE eu_page_id = '796' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser srwiki mw1002 - 5096509468 30A18A0C7 3s 2015-08-15 10:03:35 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20150715004222' WHERE eu_page_id = '196554' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser dawiki mw1010 - 5096510349 30A18AAB7 3s 2015-08-15 10:03:55 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages */ `wbc_entity_usage` SET eu_touched = '20081227200149' WHERE eu_page_id = '77' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) db1038 wikiuser bewiki mw1011 localhost 5096511142 30A18B320 2s 2015-08-15 10:04:05 UPDATE /* Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages 127.0.0.1 */ `wbc_entity_usage` SET eu_touched = '20150815100402' WHERE eu_page_id = '50792' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q5296')) TASK DETAIL https://phabricator.wikimedia.org/T107319 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: jcrespo 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
