Hi everyone!
I'm trying to deploy un upgraded version of my multi-language Magento store and after pointing Apache to the newly deployed build I got very high load from sql queries like on the screenshot below:
Those queries get piled up and some of them take hours to execute, during which CPU load goes beyond 300-400% and higher than usual memory consumption also present.
I figured out somehow that this may be related to multi-store setup which requires indexing etc. after new Magento code deployment (or some other other reason), but can't seem to find any solution to this. It looks like this is normal, but what may be causing this process? If I deploy the same Magento instance and point only one Vhost to it instead of all 4, those queries don't load the CPU.
My Magento setup is the following: current version - Open Source 2.2.7 with 4 websites configured and a total of 5 store views; newly deployed version - Open Source 2.2.8. Media folder is symlinked (if that matters) and all Apache Virtual Servers point to one symlink, which redirects to the current Magento build.
Should I do something about it or leave it like it is and wait until the queries get executed (though it is possible that those queries might crash the server occasionally)?
