Insert into search_tmp… queries never ends

Introduction.

Magento uses MySQL’s fulltext for search. From time to time when your store has many search request MySQL can have many queries like:

INSERT INTO search_tmp...
Why it happens?

It happens when your store has many catalogsearch request.

How to fix this INSERT INTO search_tmp issue?

Will be fixed since Magento 2.3.4.

Hotfix/another fixes

The best fixes for the following issue is not to use MySQL for catalogsearch. We strongly recommend using Elasticsearch or Sphinx for the catalogsearch on Magento. If you don’t want to switch search Engine you can try to rate limit your catalogsearch requests.

You can find more Magento bugs by link https://linuxnotes.org/category/magento/

Viva La Linux!

Leave A Comment