• 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. vncviewer: command not found
  2. dolt clone: Clone a repository into a new directory
  3. CentOS / RHEL 6,7 : How to configure hugepages
  4. CentOS / RHEL : How to install a specific version of rpm package using YUM
  5. Understanding SELinux Booleans
  6. RCRON – Setup High Availability of cron Jobs
  7. pdbedit: command not found
  8. Using vmstat to troubleshoot performance issues in Linux
  9. CentOS / RHEL 5 : How to Boot into Rescue Mode
  10. How to Restart Network Services in CentOS/RHEL 8

You May Also Like

Primary Sidebar

Recent Posts

  • “glab repo” Command Examples
  • “glab release” Command Examples
  • “glab pipeline” Command Examples
  • “glab mr” Command Examples

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright