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