I'm having these two main issues below in my Magento 2.3.2 Enterprise Cloud.
- Heavy SQL load and site performance issues.
- Long-running and stuck CRON.
How could I solve it?
Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.
Sign up to join this communityI'm having these two main issues below in my Magento 2.3.2 Enterprise Cloud.
How could I solve it?
Flat tables and indexers enabled.
Starting with Magento 2.1.x and above, the use of a flat catalog is no longer a best practice and is not recommended. Continued use of this feature is known to cause performance degradation and other indexing issues. To disable the flat catalog:
In the Magento Admin, navigate to Stores > Settings > Configuration.
In the panel on the left under Catalog, choose Catalog.
Expand the Storefront section, and do the following:
When complete, click Save Config. Then when prompted, refresh the cache.
php bin/magento cache:flush
If you can't change the Use Flat Catalog Category and Use Flat Catalog Product to No because the options are greyed out disable flat indexers in app/etc/config.php
:
php bin/magento indexer:set-mode schedule
flat_catalog_product
and flat_catalog_category
- change them from 1 to 0 to disable them.php bin/magento app:config:import
php bin/magento indexer:status
php bin/magento cache:flush
Reference: https://support.magento.com/hc/en-us/articles/360034631192