Here is a more clear summary of what is happening:
Ever since I upgraded to 22.214.171.124, 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 126.96.36.199. Attached is the actual MySQL query from the example product above. As you can see, it’s very long.
Can anyone please help?