jcrespo added a comment.
so 200K per minute overall is approximately 200000/60/3 (db1126 has a third of the main, non special traffic) = 1000 QPS max per server. I would categorize this as frequent, normally those should have a latency of 0.01 seconds or less in average (and for that, that meas not reading more than 1000 rows). There are not hard limits, this is approximately the aim to go for the average query. I believe up to 1000 writes and 10000 rows read can read efficiently on that time. This will put between 20 and 50 the batch size. The 9 advice was related to bad plan being chosen due to eq_dive_range_limit being 10, but as far I can see, it has no effect here due to the type of query. The issue is that if that amount of reads have to happen anyway, just they will be sent in batches, unless we slow down the query rate somehow, this will fix nothing-- it will make the database happy, but will move the "slowdown" of the overal HTTP call to the app server. Please take my advice as a very relative general one, it is the result on server performance what will put the limits, not me, I just can make predictions based on the data provided :-D TASK DETAIL https://phabricator.wikimedia.org/T246159 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup, jcrespo Cc: jcrespo, Marostegui, Aklapper, ArielGlenn, Addshore, WMDE-leszek, Ladsgroup, Hazizibinmahdi, Beast1978, Un1tY, Hook696, Daryl-TTMG, RomaAmorRoma, E.S.A-Sheild, Iflorez, darthmon_wmde, alaa_wmde, Meekrab2012, joker88john, CucyNoiD, Nandana, NebulousIris, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Af420, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, WSH1906, Lewizho99, Maathavan, _jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
