jgbyvan

I think we hit this same issue this morning, it screwed the pooch on our regular product release 🙁

Our forensics so far have found that one of these queries gets lodged in the mysql every time we load the edit.php?post_type=product&all_posts=1 page… they run busy, so drive mysql to use all the CPU. And they persist, forever. If you try to run the query manually it just hangs similarly.

After a lot of fossicking we have got rid of the issue with a hack in: ./woocommerce/packages/woocommerce-admin/src/API/Products.php

At the top of the get_items function we have inserted return ""; – suddenly our whole website is both working again and way faster than it was previously. I gather this is part of the REST API that’s presumably used in some AJAX shit? Anyway – I’ve no idea what I’ve broken but all core site functions seem to work, and customers can buy product again… hurrah.

Certainly more investigation and a proper fix needed here though.