fbpx
Troubleshooting the Magento 2.3 Upgrade: Decoding High CPU Load and Proposing Effective Solutions

Troubleshooting the Magento 2.3 Upgrade: Decoding High CPU Load and Proposing Effective Solutions

The Magento 2.3 upgrade led to an unexpected rise in database CPU load due to a recurrent query from the 'Popular Search Term Cache' feature. An analysis revealed that 'num_results > 0' condition of the query was responsible for the increased execution time. The 'search_query' table's growth further compounded the issue. The issue was addressed using a mix of understanding, creativity, and technical intervention. The solutions incorporated removal of the 'num_results > 0' clause, indexing the 'search_query' table, optimizing the query by removing the 'DISTINCT' operator, and introducing asynchronous insertion of search terms. These improvements did not only solve the immediate problem, but also showed potential for future optimizations, underlining the importance of clever problem-solving in technological solutions for maintaining innovation, efficiency, and user satisfaction.

Full article here: https://medium.com/@lawsuithelpdesk/troubleshooting-the-magento-2-3-upgrade-decoding-high-cpu-load-and-proposing-effective-solutions-7d91e93e2f22

YouTube
LinkedIn
LinkedIn
Share