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

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • 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. How to block non-root user from creating crontab entry in Linux
  2. Linux “seq” Command Examples
  3. Invalid ABI Option abi=aapcs-linux
  4. mkswap Command Examples in Linux
  5. CentOS / RHEL : Configure yum automatic updates with yum-cron service
  6. UNIX/Linux : Access control lists (ACLs) basics
  7. mkinitrd: command not found
  8. UNIX / Linux : how to force user to change their password on next login after password has reset
  9. How to Create/Format/Extend Virtual Data Optimizer(VDO) Volumes using Cockpit Web Console in CentOS/RHEL 8
  10. firejail: command not found

You May Also Like

Primary Sidebar

Recent Posts

  • protonvpn-cli Command Examples in Linux
  • protonvpn-cli connect Command Examples
  • procs Command Examples in Linux
  • prlimit: command not found

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright