更新时间:2023-11-30 12:03:46
当您的产品数量超过
<global>
<catalog>
<product>
<flat>
<max_index_count>64</max_index_count>
</flat>
</product>
</catalog>
</global>
索引.此最大值通常在app/code/core/Mage/Catalog/etc/config.xml
中定义,并且与默认的mySQL安装允许的最大64个键匹配,直到它们出现错误
indexes. This maximum usually is defined in app/code/core/Mage/Catalog/etc/config.xml
and matches the maximum number of 64 keys allowed by default mySQL installations, before they error with
ERROR 1069: Too many keys specified. Max 64 keys allowed
您的问题不是产品具有多少属性,而是可过滤和/或可排序的属性(当然, all 除外).
Your problem is not how many attributes your products have, but how many of them are filterable and/or sortable (except all your attributes are, of course).
跟踪Mage_Catalog_Model_Resource_Product_Flat_Indexer::getFlatIndexes()
,以了解Magento如何达到总共521个索引.
Trace Mage_Catalog_Model_Resource_Product_Flat_Indexer::getFlatIndexes()
to find out how Magento reaches a total of 521 indexes.
要进行快速检查,您还可以查看catalog_eav_attribute
表,并检查可过滤(is_filterable = 1
)和/或可排序(used_for_sort_by
= 1)的属性的数量
For a quick check you can also have a look at your catalog_eav_attribute
table and check how many attributes are filterable (is_filterable = 1
) and/or sortable (used_for_sort_by
= 1)