- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-14-2020
03:15 PM
06-14-2020
03:15 PM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-14-2020
07:59 PM
06-14-2020
07:59 PM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-14-2020
09:48 PM
06-14-2020
09:48 PM
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