Skip to content
Lawsuit Help Desk

Lawsuit News Center

Decoding the Magento 2.3 Upgrade: Unveiling the Mystery of Rising Database CPU Load and Strategies to Counteract

Decoding the Magento 2.3 Upgrade: Unveiling the Mystery of Rising Database CPU Load and Strategies to Counteract

The Magento 2.3 upgrade has resulted in a surge in database CPU load, chiefly due to an inefficient query associated with the Popular Search Term Cache feature. This issue is tied to the size of the search_query table and the use of the DISTINCT operator. The problem, affecting multiple versions of Magento, impairs user experience and conversion rates, thereby demanding immediate attention from the Magento development team. The problematic query is causing a longer execution time, negatively impacting search results speed, user experience, and ultimately leading to a drop in conversion rates and revenue. The key factors aggravating this issue are the size of the "search_query" table and the unnecessary use of the DISTINCT operator, which can be removed without impairing search results. This issue being prevalent in different Magento versions, signals an urgent need for resolution.

Full article here: https://ipllfirm.com/all-insights/news-and-articles/decoding-the-magento-2-3-upgrade-unveiling-the-mystery-of-rising-database-cpu-load-and-strategies-to-counteract/