• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • VCS
  • Interview Questions
  • Database
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Insert into search_tmp… queries never ends

by admin

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 fix 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.

Filed Under: Linux

Some more articles you might also be interested in …

  1. code: Cross platform and extensible code editor
  2. diskonaut: Terminal disk space navigator, written in Rust
  3. just Command Examples in Linux
  4. ipfs Command Examples
  5. CentOS / RHEL : How to find which user run a specific command?
  6. deluge-console: An interactive interface for the Deluge BitTorrent client
  7. aa-disable: command not found
  8. printf: command not found
  9. fc: Open the most recent command and edit it
  10. inxi Command Examples in Linux

You May Also Like

Primary Sidebar

Recent Posts

  • Vanilla OS 2 Released: A New Era for Linux Enthusiasts
  • mk Command Examples
  • mixxx Command Examples
  • mix Command Examples

© 2025 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright