BenHur Posted February 18 Share Posted February 18 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, Link to comment Share on other sites More sharing options...
Adlago Posted February 18 Share Posted February 18 Have you tried rebuild search index? Link to comment Share on other sites More sharing options...
Marc Stridgen Posted February 19 Share Posted February 19 Also please check you have nothing showing up in the support section of your admin CP. Link to comment Share on other sites More sharing options...
Recommended Posts