How to optimize magento 2 database After Migration from Magento 1 to Magento 2 ?

[radiantweb]

Hello,

Can anybody suggest a solution to make database optimization after migration from Magento 1.9.x to Magento 2.3.4 ?

[Manish Mittal]

@radiantweb 

What kind of optimization you are looking? You can check new relic for your long queries or taking time queries.

You can remove unnecessary attributes. You can disable not used modules. You can optimize queries too. 

[radiantweb]

After migration the database size is around 18GB and it is getting even bigger whenever i reindex. Also reindexing process takes  around 72 hours to complete. I have 1 store with 1.6 Million products.

[Manish Mittal]

Hello @radiantweb 

You can put indexs on update on schedule and set a cron. Apart from that check sleep queries, if sleep queires are running you should kill all and find out what is the cause of sleep queires.