Database being hit with thousands of search queries causing high load

  • Hi,

    I have a bit of a strange issue. Running this site several years now, but never encountered anything like this. Two weeks ago (according to Google Search Console excluded noindex pages and me manually checking mysql processes), more and more hits to the database started to occur. All very similar:

    SELECT COUNT(*) FROM xx_posts WHERE 1=1 AND (((xx_posts.post_title LIKE '%google=662496898\\_session/feed/rss2/<a_href/page/3//page/1/&usg=AOvVaw1w32-jX45qQEhTH-iBghzF

    The part after rss2 tends to change. No idea where this is coming from, but it seems to be increasing and causing the server load to increase as well.

    Has anyone seen this before? Or hints to find where this is coming from? No new plugins or themes were installed in the past few months. Everything is up to date.

    Thank you in advance.
    Jonas.

Viewing 1 replies (of 1 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Install a plugin like WordFence. It might block some of these searches and its logging can tell you where they’re coming from.

Viewing 1 replies (of 1 total)
  • The topic ‘Database being hit with thousands of search queries causing high load’ is closed to new replies.