[login to view URL]
Essentially, this is a Magento bug where it spawns this type of query, despite the fact that it is a query designed for the MyISAM storage engine, whereas Magento currently runs the InnoDB storage engine. Because this query is not designed to work with Magento in its current state, the queries stay stuck in MySQL and never complete, causing downtime for your site. Modifying the code outlined in the article should prevent this issue from continuing to occur for you.
20 freelancers are bidding on average $37 for this job
Hi, I have more than 7 years of experience. I can easily fix this issue. My portfolio: [login to view URL] Let me know if you are interested. Regards, Mayur