| jcrespo added a comment. |
@Ladsgroup After looking at database logs, I can confirm there is something really bad with the wikidata new item logic- each request has to lock the table, which esentially serialized creations, puts a limit on the number of items that can be created per second (in a bad way- consuming resources-, not in a good, controlled way), and creates huge contention. See the top 2 queries of the past 10 hours (spike happened at the time for the report). Please escalate, this is a quite ugly bug and a real performance hog:
Hits Tmax Tavg Tsum Hosts Users Schemas 292 15 9 2,694 db1070 wikiuser wikidatawiki SELECT /* Wikibase\SqlIdGenerator::generateNewId */ id_value FROM `wb_id_counters` WHERE id_type = 'wikibase-item' LIMIT 1 FOR UPDATE /* ed91e42b47c2b64365221161239e8e4b db1070 wikidatawiki 3s */ 55 16 10 569 db1070 wikiuser wikidatawiki SELECT /* WikiPage::lockAndGetLatest */ page_latest FROM `page` WHERE page_id = '923832' AND page_namespace = '0' AND page_title = 'Q974144' LIMIT 1 FOR UPDATE /* 3dafdbceffd65e9535ff1dcc6f43281b db1070 wikidatawiki 11s */
TASK DETAIL
EMAIL PREFERENCES
To: jcrespo
Cc: jcrespo, Marostegui, Ladsgroup, Aklapper, Billinghurst, Rayssa-, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Wikidata-bugs, aude, Mbch331, Jay8g
Cc: jcrespo, Marostegui, Ladsgroup, Aklapper, Billinghurst, Rayssa-, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Wikidata-bugs, aude, Mbch331, Jay8g
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
