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… Read More »Every time I run setup:upgrade command it execute queries like ANALYZE TABLE for every table

How to make id field auto increment in db_schema.xml in mageno 2.4?

I have a custom table created through db_schema.xml (code below): <?xml version=”1.0″?> <schema xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xsi:noNamespaceSchemaLocation=”urn:magento:framework:Setup/Declaration/Schema/etc/schema.xsd”> <table name=”Magebit_Faq_Question”> <column xsi:type=”int” name=”id” unsigned=”true” nullable=”false” padding=”10″ identity=”true” comment=”id”/> <column xsi:type=”text” name=”question” nullable=”false” comment=”Question”/> <column xsi:type=”text” name=”answer” nullable=”false” comment=”Answer”/> <column xsi:type=”smallint” name=”status” nullable=”false” default=”0″… Read More »How to make id field auto increment in db_schema.xml in mageno 2.4?