cancel
Showing results for 
Search instead for 
Did you mean: 

Magento 2 Search Is loading very slow and mysql server goes away

Magento 2 Search Is loading very slow and mysql server goes away

Hello there,

 

I have 1.5 million products.

Migrated from magento 1.9 to Magento 2.3.4

My Search is always loading the page while searching and it gives error with Gateway Timeout.

So search is loading very slow and it never returns results.

How can i solve this issue ?

2 REPLIES 2

Re: Magento 2 Search Is loading very slow and mysql server goes away

Hi @radiantweb 

Kindly refer below link :

https://magenticians.com/magento-optimization/

It may help you to improve search speed.

If issue resolve, please click on 'Kudos' & Accept as Solution!

Problem solved? Click Accept as Solution!

Re: Magento 2 Search Is loading very slow and mysql server goes away

Hello @radiantweb 

 

1) first disable Flat Catalog

2) move to search engine based on elasticsearch

 

Then do reindex and try it

 

 


Problem solved? Click Kudos & Accept as Solution!
Sunil Patel
Magento 2 Certified Professional Developer & Frontend Developer