Skip to content
Lawsuit Help Desk

Lawsuit News Center

Decoding the Magento 2.3 Update: The Unexpected Surge in Database CPU Load and the Hidden Culprit Within Search Queries

Decoding the Magento 2.3 Update: The Unexpected Surge in Database CPU Load and the Hidden Culprit Within Search Queries

The Magento 2.3 update unexpectedly led to an increased database CPU load. The culprit is a search query that is severely affecting system performance, particularly for databases loaded with millions of search_query records. A closer look reveals two main problems: the num_results > 0 check, and the redundant DISTINCT operator – both contribute to the high CPU load. By removing these elements, execution time decreases significantly. The persistence of the issue in subsequent editions indicates a design flaw in Magento. Proposed solutions include overwriting the 'execute' function, adding an index to the search_query table, and removing the DISTINCT operator from related queries. This highlights the need for continuous site updates and code optimization to prevent such issues.

Full article here: https://ipllfirm.com/all-insights/news-and-articles/decoding-the-magento-2-3-update-the-unexpected-surge-in-database-cpu-load-and-the-hidden-culprit-within-search-queries/