Slow_query in the last version

[BenHur]

Hi,

My forum is quite big indeed but here is one slow query (in the log of mysql) that comes a few times :
(mysql 8 and the last version of the forum)

# Time: 2024-02-18T10:46:29.305623Z
# User@Host: XXXXXX[XXXXXXXXXXXX] @  [10.27.40.99]  Id: 73771
# Query_time: 1.176123  Lock_time: 0.000002 Rows_sent: 15  Rows_examined: 115424
SET timestamp=1708253188;
/*XXXXXX::av_XXXXXXXXXXXX::IPS\Content\Search\Mysql\_Query::search:253*/ SELECT main.* FROM `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\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) ) AND index_author=3539 AND ( index_permissions = '*' OR ( FIND_IN_SET(2,index_permissions) ) ) AND index_hidden=0 ORDER BY index_date_created DESC LIMIT 0,15;

 

# Time: 2024-02-18T05:04:42.734549Z
# User@Host: XXXXXX[XXXXXX] @  [10.27.40.99]  Id: 50251
# Query_time: 1.796573  Lock_time: 0.000001 Rows_sent: 15  Rows_examined: 192661
SET timestamp=1708232680;
/*XXXXXX::XXXXXX::IPS\Content\Search\Mysql\_Query::search:253*/ SELECT main.* FROM `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\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) ) AND index_author=3804 AND ( index_permissions = '*' OR ( FIND_IN_SET(2,index_permissions) ) ) AND index_hidden=0 ORDER BY index_date_created DESC LIMIT 0,15;

Thanks for your help !

Regards,

 

 

 

[Adlago]

Have you tried rebuild search index?

[Marc]

Also please check you have nothing showing up in the support section of your admin CP.