1. elasitc search keeps crashing with magento 2 *maybe due to below issue
2. find out mysql magento which queiries are not using indexes?
3. mysqlmyadmin shows thousands of search joins mysql queries without indexes maybe killing elastic search
4. it shows The number of joins that do not use indexes. If this value is not 0, you should carefully check the indexes of your tables.
5. maybe find out what the queries are we can can indexes which will speed it up
6. the whole site is using the search feature to filter products so joining tables
7. need to find out why and stop elastic search crashing as it kills Magento 2 products results front end
64 фрилансеров(-а) готовы выполнить эту работу в среднем за $226
Hello Sir, I am a magento 2 developer with 6 years of full-time working experience in it. And, I can help you with your elasticsearch issue. Please initiate the chat so that we can continue.