It is best practice to remove non-used attribute sets. Exceeding the maximum attribute sets causes performance degradation and potential outages.
Affected products and versions
- Magento Commerce, all supported versions
- Magento Commerce Cloud, all supported versions
Best practice
Remove attributes that you don't use to ensure that the site is not exceeding the maximum recommended number of attribute sets, which is 1000. You can check the number of attribute sets with the following MySQL query:
SELECT COUNT(*) AS 'attribute_set' FROM *${TABLE_PREFIX}*eav_attribute_set;
Where ${TABLE_PREFIX} is a table prefix which can be found in environment variable MAGENTO_CLOUD_RELATIONSHIPS.
To see this variable, refer to DevDocs Magento Commerce Cloud > Cloud Variables.
Related reading
DevDocs Magento User Guide > Product Attributes > Attribute Set.