The websites on our hosted server lock up any time we make an edit to a catalog item through the Magento admin console. We can update products without a problem using Magento Store Manager from MagneticOne.
In doing some troubleshooting in the Webhost Manager, I can see the trouble in the SQL processes running when we try to do an update. It appears the catalog table gets locked to start a MySQL transaction, then the remaining SQL queries are not able to execute. Meanwhile the catalog table is inaccessible for any website navigation, search, etc. The SQL queries just start stacking up waiting for the lock file to clear
The lock query times out after 15 minutes or so and things go back to normal, but the product records are never updated as requested.
Any insights on how to proceed would be greatly appreciated.