cancel
Showing results for 
Search instead for 
Did you mean: 

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

Highlighted

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

Hello,

 

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

3 REPLIES 3
Highlighted

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

@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. 

Manish Mittal
https://www.manishmittal.com/
Highlighted

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

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.

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

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.

Manish Mittal
https://www.manishmittal.com/