Skip to content

Every time I run setup:upgrade command it execute queries like ANALYZE TABLE for every table

I am using Magento 2.4.3-p2 and mysql 8.
Every time I run Magento php bin/magento setup:upgrade
It will execute below queries for all the tables.

ALTER TABLE `admin_analytics_usage_version_log` DEFAULT CHARSET='utf8'
ANALYZE TABLE admin_analytics_usage_version_log

Due to this upgrade command takes more time.
Please anyone know how to fix this problem?