Magento 2.3's upgrade resulted in a surprising increase in database CPU load, linked to the 'Popular Search Term Cache' feature. The increase was due to a query associated with the feature, affecting the performance of numerous eCommerce sites. Designed to enhance user experience by recording popular search terms, the feature inadvertently led to system issues when combined with the num_results > 0 component. Specifically, the execution time of the query increased, reducing overall efficiency. Possible solutions include tweaking the query structure, strategically managing search terms, or overriding the function associated with the issue. Dealing with high search term cardinality may require unconventional approaches like asynchronous insertion. Notably, this problem has remained in Magento versions up to 2.4.4-p1, affecting website efficiency and admin functionality. This issue's identification offers an opportunity for further learning and innovation in combating eCommerce challenges.
Full article here: https://lawsuithelpdesk.com/unmasking-the-hidden-culprit-the-unexpected-database-cpu-load-surge-in-magento-2-3-and-how-to-tame-it/