I have a Cron setting on the server to run a custom import profile every day at midnight. Thousands of products are created or updated from this profile. The table "core_url_rewrite" will be a big day by day. Magento Indexer does not work properly when it is running from the Magento backend. he stopped with a message.
I am trying to start the Magento pointer from the command line. but the exception is locking the table "core_url_rewrite". if this table is truncated and started by the Magento indexer, it works fine, but when the user import profile updates or inserts the product, it again crashes and raises the same exception.
What would be the best solution for this? It is not recommended to crop the table every time the Product is created / updated by the user import profile daily.
Any good suggestion would be appreciated.
source
share