Skip to content
Lawsuit Help Desk

Lawsuit News Center

Breaking the Chains of Slow Performance: Unraveling Magento 2.3 Database CPU Load Spike Mystery and Pioneering Solutions

Breaking the Chains of Slow Performance: Unraveling Magento 2.3 Database CPU Load Spike Mystery and Pioneering Solutions

The transition to Magento 2.3 has caused increased database CPU load on eCommerce sites with high traffic, due to an issue with the 'Popular Search Term Cache' feature. Performance issues are primarily linked to a query condition, num_results > 0. While its removal improved performance, it didn't entirely solve the issue. A temporary fix involved modifying the execute function in the Magento_CatalogSearch module, but this didn't address the root problem. The DISTINCT operator was another performance burden, especially for numerous search_query table records. Its removal substantially enhanced keyword search performance. To avoid temporary patchwork and ensure long-term efficiency, Magento could consider solutions like batch insertion of search terms, decrease the number of tracked search terms, or reevaluate the Popular Search Term Cache. These preliminary findings aim at eventual optimization of Magento's performance.

Full article here: https://ipllfirm.com/all-insights/news-and-articles/breaking-the-chains-of-slow-performance-unraveling-magento-2-3-database-cpu-load-spike-mystery-and-pioneering-solutions/