Performance – woocommerce, queue

Hey
I got lightning fast help last time, so hoping I will be as lucky as before 🙂
We’ve got a woocommerce installation on a pretty decent server, 16GB/not sure how many cores. Database is big one 4GB+, with previous orders, but not that many products (less than 200 including variations). Most of them are composition product with around 20 variations each and 3-4 components. There are also several ACF fields in play, meta boxes and so on, the usual stuff. We are broadcasting to a single instance (for now).

Saving any of the products kills the server, 503 on the backend side, but – and that is the main problem – on the front end side as well. It obviously is reaching the php timeout limit. We have queue addon enabled and it’s set to 1 product at a time. While saving the server takes as much as 4Gb of memory but the processor doesn’t go above 4%.

Any way we can tweak options (php/broadcast/wp) to make things better or at least debug the bottleneck? Any suggestions on what to look at?