ElasticSearch Magento 2 Mysql Issues
Budget: $30 – $250 USD
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
/shop/wheels?q=&carmakers=&carmakermodel=&carmodel=&product_list_order=name&product_list_dir=asc&cat=94
7. need to find out why and stop elastic search crashing as it kills Magento 2 products results front end
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
/shop/wheels?q=&carmakers=&carmakermodel=&carmodel=&product_list_order=name&product_list_dir=asc&cat=94
7. need to find out why and stop elastic search crashing as it kills Magento 2 products results front end