All geek questions in one place

Inconsistency in the number of tables in each Magento database. Installing one version.

I am currently using Magento version 1.4.0.0. For different clients, when I install the same version of Magento, I get a different number of tables in the database of each client.

I think the normal total number of tables is 267, but this prediction may be wrong. Please correct my expression or mention regarding the number of default database tables that should be installed for Magento CE version 1.4.0.0.

However, sometimes I get 258 number of tables, sometimes 260, and sometimes 265. This has become a big area of ​​pain for me, understanding the correct number of database tables that should be installed by default. Can someone please tell me why this is happening for Magento CE version 1.4.0.0?

Any help is appreciated.

Edit: -
I often see related Bundle Products tables or tables with the suffix "_idx" missing for a long time.
If the structure of the Magento database from among the tables depends on the use of the directory (say, Bundle / Configurable / Grouped), then this will be very error-prone for each administrator and will create more confusion for them to configure / create catalog products.

+3
source share
1 answer

Magento creates temporary tables for several reasons, including re-indexing actions and setting up your site (for example, a flat catalog, etc.). Can you clarify which "extra" tables you see? These are probably temporary tables or caching / index tables.

Thanks Joe

+1
source

Source: https://habr.com/ru/post/1753649/

More articles:


All Articles