Here is a more clear summary of what is happening:
Ever since I upgraded to 126.96.36.199, some products take forever (up to 5 min) to save in Magento. It only happens to simple products that belong to 2 or more bundle products. Some bundle products also do that. During the save process two things happen:
1. MySQL process takes up 100% of CPU for about 5 minutes.
2. During that time, I get multiple errors “SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded. Mostly search related.
For example, there are 2 sets of MySQL queries that run when I save a certain simple product (which I’m guessing is because this product is associated with 2 different bundle products). Each of these queries takes about 120 seconds to run (and takes up about 3 pages of normal typed document), and because I have the index management set to “Update on Save” for the Product Prices index, every time you save a product, it has to re-index the product prices for each updated bundled product.
I’ve disabled the “Update on Save” feature of the Index Management, and saving the product takes about 10 seconds now, the only downside is that I’ll have to manually refresh the Product Prices index, but updating that manually only takes about 10 seconds as well.
This is only happening in 188.8.131.52. Attached is the actual MySQL query from the example product above. As you can see, it’s very long.
Can anyone please help?