Binlogs Xibo v4 MySQL 8

CMS Version

Xibo V4.1.2

Installation Method

Docker install default MySQL

Operating System

ubuntu 24.04.2 LTS

Issue

We are facing the issue that the binlog files in /shared/db are getting way too large (19Gb and growing). We found that the default binlog expire time is 30 days in MySQL8.

We tried to clean up the logs and change the expire time in the MySQL instance but the “cms” user has not the needed permissions to do so. As for the “root” user the password setting is set to randomize but we couldn’t find it in the logs as the container is started.

How can these settings be changed?

Thanks in advance

Best regards

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.