Jump to content

What is this slow query ?

Featured Replies

Posted

I'm seeing large numbers of the following query with different "INDEX_TAG IN" terms taking up to 90 seconds each to run:

Quote

/*IPS\Content\Search\_Results::count:538*/ SELECT COUNT(*) FROM `ibf_core_search_index` AS `main` WHERE ( ( index_class IN('IPS\\core\\Statuses\\Status','IPS\\core\\Statuses\
\Reply') ) OR index_class='IPS\\forums\\Topic\\Post' OR ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) ) AND index_item_index_id=index_id AND
index_item_index_id IN ( SELECT index_id FROM `ibf_core_search_index_tags` AS `core_search_index_tags` WHERE ( index_tag IN('obama') ) ) AND ( index_permissions = '*' OR ( (
FIND_IN_SET(2,index_permissions) ) ) ) AND index_hidden=0

What particular event or process is creating these as it's wreaking havoc on performance. Is a search engine bot flooding something ?

Is this is a query produced by the 'reindexing posts' background process which is currently running ?

Edited by dal

If it's a search engine crawler, I'd advise turning the search engine off for guests.

25 minutes ago, dal said:

Is this is a query produced by the 'reindexing posts' background process which is currently running ?

Most likely.

That looks like it's probably a tag search (click a tag next to the topic title), though they aren't supposed to take that long to execute.

Archived

This topic is now archived and is closed to further replies.

Recently Browsing 0

  • No registered users viewing this page.