When I create any entry in admin like product or custom module entry then table assigns +3 increment ids like 1,3,6,9....1569,1572 & so on...
Is there any setting ? I need to do to assign it in sequence way like 1,2,3,...
Any idea? please share.
Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.
Sign up to join this communityWhen I create any entry in admin like product or custom module entry then table assigns +3 increment ids like 1,3,6,9....1569,1572 & so on...
Is there any setting ? I need to do to assign it in sequence way like 1,2,3,...
Any idea? please share.
Looks like the reason for this is that Db configured for replication. Verify MySQL setting auto_increment_increment (sql: show global variables like 'auto_increment_increment') I believe it configured as 3.