NextCloud binlog files taking too much space

ℹ️ Support 📦 Appliances (Docker, Snappy, VM, NCP, AIO)
1

I have installed Nextcloud Hub II (23.0.0) in a Docker environment. The data directory of NextCloud lists many log files named

binlog.00XXXX

files, each is 1GB large and it consumes almost all of my disk space.

I have found explanations on how to delete these log files by connecting to mysql using the mysql client and remove old logs by the following commands

sudo nextcloud.mysql-client -S /tmp/sockets/mysql.sock -u root

PURGE BINARY LOGS TO ‘binlog.0000XX’;

However, this does not seem to work with a dockerized installation?

2

the question is not related to Nextcloud but to the back-end Mysql/MariaDB instance. The way you manage your SQL instance differ from the bare-metal install but definitely it is possible to configure size and number of transaction logs in dockerized Mysql installations (I did :wink: )