The declarative scheme was introduced in Adobe Commerce on cloud infrastructure version 2.3. For reference, see Configure declarative schema > table node in our developer documentation. In the db_schema.xml file declaring the table, set the engine attribute value for the corresponding table node to innodb. NOT IN ('mysql', 'information_schema', 'performance_schema', 'sys') TABLES WHERE engine='myisam' AND table_schema If you have already installed an extension, run the following query to determine whether the database has any MyISAM tables: SELECT table_schema, CONCAT(ROUND((index_length+data_length)/1024/1024),'MB')ĪS total_size FROM information_schema. You can analyze the third-party module code before installing it, to determine if it uses MyISAM tables. After you install a third-party module, you should check the database to identify any tables in MyISAM format and convert them to InnoDb. However, some third-party modules (extensions) can introduce tables in the MyISAM format. Avoid running DDL (Data Definition Language) statementsĪdobe recommends using the InnoDb database engine, and in the out-of-the-box Adobe Commerce installation, all tables in the database are stored using the InnoDb engine.Upgrade ECE-Tools to version 2002.0.21 or higher.Use ElasticSearch instead of MySQL native FULLTEXT indexes.The recommendations are relevant for both Starter architecture and Pro architecture customers.Ĭlick on the links below to see recommendations:
#TABLEPLUS ELASTICSEARCH HOW TO#
This article explains how to improve the performance of your Adobe Commerce on cloud infrastructure store by working efficiently with the database. Refer to Install and configure Elasticsearch. You must have Elasticsearch host setup and configured prior to installing version 2.4.0. MySQL catalog search engine will be removed in Adobe Commerce 2.4.0.
0 kommentar(er)
