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,

Hello, Unfortunattely, after several years, our forum is not active anymore. But with a lot of post, we want to keep the history available. We're looking for a solution read only. Do you know a solution for having an export of the site in static ? (no more interaction / no more registration/reply and no more database etc.) I will try HTTrack Website Copier later this week but maybe if you know something Thanks again,

Thanks Mark for your answer. I will look to the cron. We have 1,1 million messages so if the top 10% could be cached it could be better maybe 😉 I upgraded to 16 Gb so we will see. With 1,1 messages, is it possible to have a idea of the size of the db should be ?

Hello team, The table become too big (>7 G with 535 000 rows). My provider have a limit for the SQL (8 Go) so is it a setting in order to limit the cache to the last 5000 posts for example ? Thanks again, Benjamin Mysql : v5.7.36-log