fbpx
Unveiling the Hidden Culprit: How Magento 2.3 Upgrade Unleashes a Barrage on Your Database CPU Load

Unveiling the Hidden Culprit: How Magento 2.3 Upgrade Unleashes a Barrage on Your Database CPU Load

The Magento 2.3 upgrade, initially celebrated for its tech advancements, unexpectedly created problems by significantly increasing database CPU load. Unbeknownst to users, the 'popular search term cache' feature has slowed down search queries, with the 'distinct operator' pushing the database system into overdrive. This problem persists even in the latest 2.4-develop branch, suggesting a need for immediate correction. The 'SELECT DISTINCT COUNT(*)' query extends times to a cumbersome 23 seconds, affecting user experience. Potential solutions include eliminating the 'distinct operator', asynchronously inserting search terms, or stopping the tracking of search terms. While these solutions need more testing, they offer a hopeful avenue to improving user experience and Magento platform performance.

Full article here: https://lawsuithelpdesk.com/unveiling-the-hidden-culprit-how-magento-2-3-upgrade-unleashes-a-barrage-on-your-database-cpu-load/

YouTube
LinkedIn
LinkedIn
Share