@thecoalman thanks so much for your response. Search isn't important and I've cleaned up the search data. The remaining very large entity is PHPBB3_sessions. Can I empty this? I find little documentation about its use.thecoalman wrote: ↑Wed Apr 14, 2021 12:01 pm The contents of the search tables can be deleted in the ACP,
ACP >> Maintenance tab >> Search link on left
Search will no longer work for old posts. The index can be recreated so those posts are searchable and will likely produce slightly smaller size, how much smaller depends but without any changes to search options it will in most cases be negligible.
You can fully disable search to prevent them from being populated with new posts.
ACP >> Search Settings
If you wanted to reduce the size of those table and still keep search functional there is option there for word length. Increasing that will produce smaller index, downside is shorter words are not searchable. You can also disable indexing on individual forums on a forum's setting page. You would make these changes before recreating the search index.
See my post above.stevenospam wrote: ↑Wed Apr 14, 2021 12:55 pm The remaining very large entity is PHPBB3_sessions. Can I empty this?
david63, you're exactly right. I have the cron setting to use the system cron rather than PHPBB because the board is lightly used but it's important that digests go out regularly. I have in the system crondavid63 wrote: ↑Wed Apr 14, 2021 1:06 pmSee my post above.stevenospam wrote: ↑Wed Apr 14, 2021 12:55 pm The remaining very large entity is PHPBB3_sessions. Can I empty this?
If you empty the sessions table then it will have the effect of logging all your users out.
If you intend emptying that table I would only remove the records for user_id 1 (Anonymous User)
Code: Select all
*/5 * * * * /usr/local/bin/php /home/username/public_html/phpbb/bin/phpbbcli.php cron:run
/home/username/
is typical on and the username is typically the main domain without the .com etc. If you do not know what it is look up the value for doc_root in php information. When you use that feature you will remove all sessions from the sessions table which will have the effect of logging all your users out which could upset them if they were in the process of creating a poststevenospam wrote: ↑Wed Apr 14, 2021 9:10 pm It turns out there's a "purge sessions" selection under the General administration tab that purges the rows from the sessions table in the database.