fbpx
Unlocking Magento's Performance Mystery: Decode the Impact of Search Term Cache on CPU Load

Unlocking Magento’s Performance Mystery: Decode the Impact of Search Term Cache on CPU Load

Magento, an eminent e-commerce platform, faces a performance issue associated with a search term cache causing high database CPU load. The problem is notably related to the 'search_query' table. The challenge is intensified with Magento 2.3 upgrade and large datasets management, as evidenced by performance lag in a site with 2.7 million search terms. The root cause is the 'search_query' table, central to Magento's keyword search feature. Notably, its COUNT(*) query results in high CPU use and longer completion times, affecting performance across various Magento versions. Potential yet failed solutions include DISTINCT operator removal and asynchronous batch search term insertion. Despite efforts, the problem persists, underlining the imperative for novel, viable solutions to enhance Magento's performance and scalability.

Full article here: https://lawsuithelpdesk.com/unlocking-magentos-performance-mystery-decode-the-impact-of-search-term-cache-on-cpu-load/

YouTube
LinkedIn
LinkedIn
Share