[SOLVED] Magento 2 Error: A technical problem with the server created an error. Try again to continue what you were doing. If the problem persists, try again later.

Sometimes debugging on Magento can be annoying, specially if something just arises out of the blue, not while you are actually writing a code.

Magento Error - Technical Problem with server
If Problem Persists, try again later

This is something that occurs on Magento admin panel. As of now, it can be one out of 3 reasons, let us discuss them:

1. Admin Password

Try to change admin password, log out and log in again. This should fix it.

2. Some un compiled code or pending schema change

upgrade, compile, deploy, reindex, clean cache

rm -rf generated/* var/cache/* var/view_preprocessed/*
php bin/magento setup:upgrade
php bin/magento setup:di:compile
php bin/magento setup:static-content:deploy -f
php bin/magento indexer:reindex
php bin/magento cache:clean

3. Check for some extra output in the php files


See Line 41
One of the developers left this in index.php and this was just messing with the api calls from admin panel because it was corrupting json output.

How to stop SPAM in gmail account permanently? A guide to creating filters in Google Mail [no third party app]

SPAM, don’t we hate it when our inbox is full of credit card offers, insurance policies and billions of pounds that some rich dude left for you in his will? Everyone wants to get rid of them but somehow, some stupid website out there keeps leaking on our email address and we keep receiving stupid junk emails.

We all know that SPAM or Junk Email means unsolicited messages that you receive by email. But here is a fun fact:

Spam is named after Spam luncheon meat by way of a Monty Python sketch in which Spam in the sketch is ubiquitous, unavoidable and repetitive.

Go to Latest update of this article

UPDATE
The new filter guide is on https://github.com/harshvardhanmalpani/Spam-List
You can directly use the file filter_import_for_gmail.xml from github repository and add filters.
———

let us get started with the guide, Please be aware that this guide will remove and block the SPAM addresses permanently.

Step 1: Log in to your Gmail account

Step 2: Go to Settings

Gmail settings

Step 3: Under Filters and Blocked Addresses, Click on Create a new filter

Step 4: In the new FROM field, enter the Email addresses you want to block separated with

" OR "
quotations not required, just [space]OR[space]

and finally click Create filter with this search

Step 5: Check Delete it and Never send it to spam and Save the filter by choosing Create filter


Ready to import gmail filters now available

download here

file contents:

<?xml version='1.0' encoding='UTF-8'?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:apps='http://schemas.google.com/apps/2006'>
<title>Mail Filters</title>
<id>
tag:mail.google.com,2008:filters:1536425906073,1536425906073,1536425906074,1536425906074,1536425906075,1536425906075,1536425906075,1536425906076,1536425906076</id><updated>2018-09-08T22:28:26Z</updated><author>
<name>Harshvardhan Malpani</name>
<email>[email protected]</email>
</author><entry><category term='filter'></category>
<title>Mail Filter</title>
<id>tag:mail.google.com,2008:filter:1536425906073</id><updated>2018-09-08T22:28:26Z</updated><content></content><apps:property name='from' value='[email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected]m OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected]'/><apps:property name='shouldTrash' value='true'/>
<apps:property name='shouldNeverSpam' value='true'/>
<apps:property name='sizeOperator' value='s_sl'/>
<apps:property name='sizeUnit' value='s_smb'/> </entry><entry><category term='filter'></category>
<title>Mail Filter</title>
<id>tag:mail.google.com,2008:filter:1536425906073</id><updated>2018-09-08T22:28:26Z</updated><content></content><apps:property name='from' value='[email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected]'/><apps:property name='shouldTrash' value='true'/>
<apps:property name='shouldNeverSpam' value='true'/>
<apps:property name='sizeOperator' value='s_sl'/>
<apps:property name='sizeUnit' value='s_smb'/> </entry><entry><category term='filter'></category>
<title>Mail Filter</title>
<id>tag:mail.google.com,2008:filter:1536425906074</id><updated>2018-09-08T22:28:26Z</updated><content></content><apps:property name='from' value='[email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected]lestory.co.uk OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected]'/><apps:property name='shouldTrash' value='true'/>
<apps:property name='shouldNeverSpam' value='true'/>
<apps:property name='sizeOperator' value='s_sl'/>
<apps:property name='sizeUnit' value='s_smb'/> </entry><entry><category term='filter'></category>
<title>Mail Filter</title>
<id>tag:mail.google.com,2008:filter:1536425906074</id><updated>2018-09-08T22:28:26Z</updated><content></content><apps:property name='from' value='[email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected]'/><apps:property name='shouldTrash' value='true'/>
<apps:property name='shouldNeverSpam' value='true'/>
<apps:property name='sizeOperator' value='s_sl'/>
<apps:property name='sizeUnit' value='s_smb'/> </entry><entry><category term='filter'></category>
<title>Mail Filter</title>
<id>tag:mail.google.com,2008:filter:1536425906075</id><updated>2018-09-08T22:28:26Z</updated><content></content><apps:property name='from' value='[email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected].com OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected]'/><apps:property name='shouldTrash' value='true'/>
<apps:property name='shouldNeverSpam' value='true'/>
<apps:property name='sizeOperator' value='s_sl'/>
<apps:property name='sizeUnit' value='s_smb'/> </entry><entry><category term='filter'></category>
<title>Mail Filter</title>
<id>tag:mail.google.com,2008:filter:1536425906075</id><updated>2018-09-08T22:28:26Z</updated><content></content><apps:property name='from' value='[email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected]'/><apps:property name='shouldTrash' value='true'/>
<apps:property name='shouldNeverSpam' value='true'/>
<apps:property name='sizeOperator' value='s_sl'/>
<apps:property name='sizeUnit' value='s_smb'/> </entry><entry><category term='filter'></category>
<title>Mail Filter</title>
<id>tag:mail.google.com,2008:filter:1536425906075</id><updated>2018-09-08T22:28:26Z</updated><content></content><apps:property name='from' value='[email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected]ncodetreat.com OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected]'/><apps:property name='shouldTrash' value='true'/>
<apps:property name='shouldNeverSpam' value='true'/>
<apps:property name='sizeOperator' value='s_sl'/>
<apps:property name='sizeUnit' value='s_smb'/> </entry><entry><category term='filter'></category>
<title>Mail Filter</title>
<id>tag:mail.google.com,2008:filter:1536425906076</id><updated>2018-09-08T22:28:26Z</updated><content></content><apps:property name='from' value='[email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR va.loan.#[email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected]'/><apps:property name='shouldTrash' value='true'/>
<apps:property name='shouldNeverSpam' value='true'/>
<apps:property name='sizeOperator' value='s_sl'/>
<apps:property name='sizeUnit' value='s_smb'/> </entry><entry><category term='filter'></category>
<title>Mail Filter</title>
<id>tag:mail.google.com,2008:filter:1536425906076</id><updated>2018-09-08T22:28:26Z</updated><content></content><apps:property name='from' value='[email protected]'/><apps:property name='shouldTrash' value='true'/>
<apps:property name='shouldNeverSpam' value='true'/>
<apps:property name='sizeOperator' value='s_sl'/>
<apps:property name='sizeUnit' value='s_smb'/> </entry></feed>

Some of the spam email addresses in my filter list:

Note: You might have to create multiple filters because one search can not contain more than 1000 characters

Whole list of spammers

[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]academy.com
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]ations.world
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
va.loan.#[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]

September Update

Latest way to be followed for SPAM blocking is as follows:

Do NOT follow both the procedures, only one of these is enough

Step 1: Log in to your Gmail account

Step 2: Go to Settings

Gmail settings

Step 3: Delete all previous filters if any, and then click on Import Filters

Click on Import Filters

Step 4: Upload the xml file that you downloaded from here: Link to filters in xml
choose xml file to import

Step 5: Click on open file and then you will see that all filters are loaded. Make sure you tick Apply new filters to existing email. and then click on Create Filters

Create Filters

Step 6: There is no step 6, wait and watch. All those filters will get created and will make you rid of SPAM

Receiving money in India | Why PayPal sucks and What are the charges?

So Why is Paypal bad? No, In theory It is not bad. It is an easy mode of payment transfer when comes to my international clients. But being an Indian citizen, why I never prefer Paypal as payment mode. Let us take a look.

So, I am going to explain it with an example of payment that I received from United Kingdom.
My client sent me 103.60 GBP which at the time of transaction was equivalent to 9334.35 INR.

Stage A

Initial Fee = (4.4% + Fixed fee) * taxes as per Indian Government (Currently 18% GST)

= (4.4% of 103.6 GBP + 0.2 GBP ) x 1.18
= (4.5584 + 0.2 ) x 1.18
= 4.7584 x 1.18
= 5.614912 GBP
= 5.62 GBP was charged

So, my Paypal amount is now 97.98 GBP (103.6 – 5.62 = 97.98)

Stage B

Now for some vague reason, Paypal India stores money in USD as base currency, so My Paypal balance showed 131.64 USD instead of 97.98 GBP. The important point to note here is that value of 131.64 USD at that moment was 95.22 GBP
When I argued Paypal support guys over this conversion, first of all they did not have an answer so they assumed some different question on their own. Later on they told me:

Thank you for your reply. I know that it can be confusing when you believe that you were charged more than you should have been in fees, but I am here to help!

PayPal uses the most up-to-date conversion rates at the time that a transaction is processed, however conversion rates are fluctuating constantly, which could explain why there is a difference in conversion rates that you are seeing.

I apologize for any frustrating this situation may have caused you. -Sarah

Somebody tell me when was the last time you saw a fluctuation of 2.812% in USD-GBP index in 24hr span?
So at present scenario I am left with 131.64 USD in my Paypal balance.

Stage 3

Now I wanted that money to sit in my bank account, so obviously I needed to withdraw in INR. I requested for a withdrawal and I was bound to acknowledge a sum credit of INR 8,242.53 (Of course 4% Fee is charged for Currency Conversion to INR)
so How much I got in Total – 8,242.53 INR!
We had started with 9,334.35 INR and I received 8,242.53 INR at the end which means a total of 1,091.82 INR (11.697% ) was somewhere lost in between in form of fees or taxes.

Summary of Fees and Charges vs Money lost in each stage using Paypal

Remark Amt. Amount of Money leaked
What client paid 103.60 GBP NIL
PayPal Fees -5.62 GBP 5.425%
What I received 97.98 GBP 5.425%
Paypal Balance 131.64 USD 8.088%
What I ultimately received 8,242.53 INR 11.697%

Here is the reference sheet –
https://www.paypal.com/in/webapps/mpp/ua/useragreement-full#exhibit_A

How to tweak Magento 2 for two letter search in fulltext mode

The problem:

Magento 2 wont return any search results if the search token is 2 letters in length.

Solution:

Alter MySQL conf file. Edit my.cnf file on your server
In CentOS, use command

nano /etc/my.cnf

and add the following lines:

ft_min_word_len=2
innodb_ft_min_token_size=2

Save using CTRL+x and then restart mysqld service.
Now we need to regenerate the index in order to get updated search results. Use the following SQL commands to regenerate:

Don’t forget to replace “jack_db1” with your database name

ALTER TABLE `jack_db1`.`catalogsearch_fulltext_scope1` DROP PRIMARY KEY, ADD PRIMARY KEY (`entity_id`, `attribute_id`) USING BTREE;
ALTER TABLE `jack_db1`.`catalogsearch_fulltext_scope1` DROP INDEX `FTI_FULLTEXT_DATA_INDEX`, ADD FULLTEXT `FTI_FULLTEXT_DATA_INDEX` (`data_index`);
ALTER TABLE `jack_db1`.`catalog_eav_attribute` DROP PRIMARY KEY, ADD PRIMARY KEY (`attribute_id`) USING BTREE;
ALTER TABLE `jack_db1`.`catalog_eav_attribute` DROP INDEX `CATALOG_EAV_ATTRIBUTE_USED_IN_PRODUCT_LISTING`, ADD INDEX `CATALOG_EAV_ATTRIBUTE_USED_IN_PRODUCT_LISTING` (`used_in_product_listing`) USING BTREE;
ALTER TABLE `jack_db1`.`catalog_eav_attribute` DROP INDEX `CATALOG_EAV_ATTRIBUTE_USED_FOR_SORT_BY`, ADD INDEX `CATALOG_EAV_ATTRIBUTE_USED_FOR_SORT_BY` (`used_for_sort_by`) USING BTREE;

References:
https://magento.stackexchange.com/a/157478/32283
https://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html