Shrinking communication_log_object_entry table

[vincentb]

Hello,

I run OTRS 6. The (MariaDB) communication_log_object_entry table is growing and its size is now more than 40GB, which becomes to be a problem. (I think this growth is mainly because there is really a lot of postmaster filters that are applied to the incoming emails, and there are many incoming emails...)

I would like to shrink this communication_log_object_entry table.
Can I just delete the oldest entries (they have a create_time recorded)?
Is there some risk/inconvenience to do that?

Thank you for your insights.

[root]

Hi,

The is a Daemon cron task, CommunicationLogDelete, which runs daily. What is deleted can be configured with the settings CommunicationLog::PurgeAfterHours::SuccessfulCommunications and CommunicationLog::PurgeAfterHours::AllCommunications

By executing the command bin/otrs.Console.pl Maint::Log::CommunicationLog you can also delete entries manually.

- Roy