Jump to content

BenHur

Clients
  • Posts

    20
  • Joined

  • Last visited

Recent Profile Visitors

1,946 profile views

BenHur's Achievements

  1. 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,
  2. 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,
  3. 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 ?
  4. 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
×
×
  • Create New...