{"data":{"id":"magento2-40546","source":"github-pr","sourceRef":"magento/magento2#40546","title":"Potential Indexer Performance issue for large catalogs - Bulk Insert & Locking Entire CL table to identity the latest version","pr":{"number":40546,"url":"https://github.com/magento/magento2/pull/40546","author":"senthilengg","mergedAt":"2026-05-12T11:41:36Z","mergeCommit":"cfa55063f6f6709df9dd27277de751dacbddcdb0","headCommit":"a991384b9e14c8152509ff44d9322055fa49bdf2","baseRef":"2.4-develop","diffSha256":"31e2305863dc2519d4a28922c637d860c131454e649c1396e59928c2a54b10c9"},"issues":[{"number":40331,"url":"https://github.com/magento/magento2/issues/40331","title":"Potential Indexer Performance issue for large catalogs - Bulk Insert & Locking Entire CL table to identity the latest version","labels":["Area: Framework","Component: Framework/Mview","Issue: Confirmed","Priority: P3","Progress: PR Created","Progress: done","Reported on 2.4.x","Reproduced on 2.4.x","Triage: Dev.Experience"],"kind":"human"}],"fixedIn":null,"containingTags":[],"reportedOn":null,"codeMatch":{"2.4.6":"file-missing","2.4.6-p1":"file-missing","2.4.6-p2":"file-missing","2.4.6-p3":"file-missing","2.4.6-p4":"file-missing","2.4.6-p5":"file-missing","2.4.6-p6":"file-missing","2.4.6-p7":"file-missing","2.4.6-p8":"file-missing","2.4.6-p9":"file-missing","2.4.6-p10":"file-missing","2.4.6-p11":"file-missing","2.4.6-p12":"file-missing","2.4.6-p13":"file-missing","2.4.6-p14":"file-missing","2.4.6-p15":"file-missing","2.4.7":"conflict","2.4.7-p1":"conflict","2.4.7-p2":"conflict","2.4.7-p3":"conflict","2.4.7-p4":"conflict","2.4.7-p5":"conflict","2.4.7-p6":"conflict","2.4.7-p7":"conflict","2.4.7-p8":"conflict","2.4.7-p9":"conflict","2.4.7-p10":"conflict","2.4.8":"clean","2.4.8-p1":"clean","2.4.8-p2":"clean","2.4.8-p3":"clean","2.4.8-p4":"clean","2.4.8-p5":"clean","2.4.9":"clean"},"affectedVersions":["2.4.8","2.4.8-p1","2.4.8-p2","2.4.8-p3","2.4.8-p4","2.4.8-p5","2.4.9"],"components":["magento/framework"],"files":[{"path":"lib/internal/Magento/Framework/Mview/View/ChangelogBatchWalker.php","change":"modified","package":"magento/framework"}],"stripped":{"tests":[],"docs":[],"outsideCode":[]},"linesChanged":41,"mergeBatched":false,"excluded":null,"sections":{"description":null,"stepsToReproduce":null,"expectedResult":null,"actualResult":null,"source":null},"signatures":[],"labels":{"area":["Framework"],"component":["Framework/Mview"],"priority":"P3","severity":null,"reportedOn":["2.4.x"]},"categories":[],"triage":{"model":"@cf/cloudflare/clef","requestHash":"7a952f7d8a0254839a449baf6929481b129da0029a3ffd29eb6c1c3ac0de63a3","isBugfix":0.8687,"changeKind":{"choice":"bugfix","probabilities":{"bugfix":0.815,"feature":0.0272,"refactor":0.1164,"tests_only":0.0084,"docs_only":0.0042,"dependency":0.0057,"cleanup":0.0231},"confidence":0.6257},"scope":{"score":0.8016,"probabilities":{"0":0.4176,"1":0.3631,"2":0.2193},"confidence":0.0315},"risk":{"score":1.5332,"probabilities":{"0":0.1451,"1":0.1766,"2":0.6783},"confidence":0.2685},"area":{"choice":"framework","probabilities":{"catalog":0.0272,"checkout":0.0072,"customer":0.0052,"admin":0.0202,"graphql_api":0.0049,"framework":0.9129,"frontend":0.0069,"other":0.0155},"confidence":0.8113},"securityRelevant":0.0053,"reportedVersion":{"choice":"unspecified","probabilities":{"2.4.0":0.0046,"2.4.0-p1":0.0042,"2.4.1":0.0042,"2.4.1-p1":0.0037,"2.4.2":0.0055,"2.4.2-p1":0.0059,"2.4.2-p2":0.0068,"2.4.3":0.0092,"2.4.3-p1":0.0092,"2.4.3-p2":0.0091,"2.4.3-p3":0.0057,"2.4.4":0.0128,"2.4.4-p1":0.0063,"2.4.4-p10":0.0061,"2.4.4-p11":0.0064,"2.4.4-p12":0.0066,"2.4.4-p13":0.006,"2.4.4-p14":0.0088,"2.4.4-p15":0.0057,"2.4.4-p16":0.0064,"2.4.4-p17":0.0055,"2.4.4-p18":0.0047,"2.4.4-p2":0.0033,"2.4.4-p3":0.0032,"2.4.4-p4":0.0031,"2.4.4-p5":0.0035,"2.4.4-p6":0.0038,"2.4.4-p7":0.0039,"2.4.4-p8":0.0043,"2.4.4-p9":0.0039,"2.4.5":0.0129,"2.4.5-p1":0.0101,"2.4.5-p10":0.008,"2.4.5-p11":0.0144,"2.4.5-p12":0.0095,"2.4.5-p13":0.0094,"2.4.5-p14":0.0079,"2.4.5-p15":0.0081,"2.4.5-p16":0.0092,"2.4.5-p17":0.0082,"2.4.5-p2":0.0043,"2.4.5-p3":0.0069,"2.4.5-p4":0.0057,"2.4.5-p5":0.0052,"2.4.5-p6":0.0063,"2.4.5-p7":0.0069,"2.4.5-p8":0.0059,"2.4.5-p9":0.0049,"2.4.6":0.0181,"2.4.6-p1":0.0175,"2.4.6-p10":0.012,"2.4.6-p11":0.0122,"2.4.6-p12":0.0126,"2.4.6-p13":0.0106,"2.4.6-p14":0.0118,"2.4.6-p15":0.009,"2.4.6-p2":0.0057,"2.4.6-p3":0.0087,"2.4.6-p4":0.0098,"2.4.6-p5":0.0087,"2.4.6-p6":0.0084,"2.4.6-p7":0.01,"2.4.6-p8":0.0067,"2.4.6-p9":0.006,"2.4.7":0.0209,"2.4.7-p1":0.0129,"2.4.7-p10":0.0092,"2.4.7-p2":0.0091,"2.4.7-p3":0.0134,"2.4.7-p4":0.0184,"2.4.7-p5":0.0118,"2.4.7-p6":0.0161,"2.4.7-p7":0.0144,"2.4.7-p8":0.0103,"2.4.7-p9":0.007,"2.4.8":0.0241,"2.4.8-p1":0.0169,"2.4.8-p2":0.0209,"2.4.8-p3":0.0166,"2.4.8-p4":0.0151,"2.4.8-p5":0.0143,"2.4.9":0.0181,"unspecified":0.2465},"confidence":0.0582},"backportWorthy":{"score":1.2483,"probabilities":{"0":0.1618,"1":0.4281,"2":0.4101},"confidence":0.0665}},"curated":{"title":"Inserts indexer changed entries in batches instead of one bulk insert","description":"For large catalogs, ChangelogBatchWalker::walk() did one bulk insert of all changed entries from the changelog into the _tmp table. The walk process now does the _tmp table insert in batches, one version_id range of batch size per select, from the from version id to the last version id.","categories":[],"author":"claude-code/opus-5.5","date":"2026-10-06","reviewedBy":null},"tests":null},"_documentation":"https://magento.watch/api","_description":"Upstream fix magento2-40546 details"}