ACP2E-4496: The analytics cron job causes performance degradation during execution and increases…

Categories

Performance, Cron

Components

magento/module-analytics

Origin

adobe-commerce-support

Since QPT

1.1.80

Issue

The analytics cron job causes performance degradation during execution and increases database load.

Steps to reproduce

1. Enable MBI analytics. 1. Generate a large amount of entries in the sales_order_item table. 1. Run the analytics_collect_data cron and measure the time taken to complete.

Adobe's page lists 2.4.8 - 2.4.8-p5 as compatible; the versions below are resolved from the current QPT constraints and are the ones the tool will offer.

Adobe scheduled the permanent fix for 2.4.9.

Install

Install the Quality Patches Tool with composer require magento/quality-patches, apply the prerequisites listed for all files applicable to your distribution and version first, then run vendor/bin/magento-patches apply ACP2E-4496. On Cloud, add ACP2E-4496 under stage.build.QUALITY_PATCHES in .magento.env.yaml.

For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its ACP2E-4496/ folder into patches/composer/, merge composer.patches.json into composer.json, then run composer install. Bundle prerequisites the same way and list them first. Paths are relative to each package root, using the default -p1 level. Prefer local files when configuring composer-patches; a remote URL can change.

Patch files and compatible versions

Sources

• Adobe documentation for ACP2E-4496
• JSON API: /api/v1/patches/ACP2E-4496