Massive mariadb/config/log directory size (> 300 GB)

[simkin]

My Booklore app with the default docker compose , is eating up lots of disk space, seemingly related to the mariadb log usage. Imo this needs to get improved.

For now I commented out the following config entries

# ...
#log_bin                 = /config/log/mysql/mariadb-bin
#log_bin_index           = /config/log/mysql/mariadb-bin.index
# ...

I also added the following COMMAND to the mariadb container but that results in the container failing to startup:

healthcheck:
      test:
        - CMD
        - mariadb-admin
        - ping
        - -h
        - localhost
      interval: 5s
      timeout: 5s
      retries: 10
    command: ["mysqld", "--skip-log-bin"]
    networks: {}

[Duckfromearth]

DId commenting out those entries seem to help?

[simkin]

DId commenting out those entries seem to help?

Yes, that adresses the issue

[jasdjensen]

So glad you mentioned this.. I had a gig of logs and it stopped working. Thank you for confirming my suspicion. I'm commenting out the logs in the database config as stated above. Hopefully that fixes the issue. I have a huge library so this is necessary.

...

#log_bin = /config/log/mysql/mariadb-bin #log_bin_index = /config/log/mysql/mariadb-bin.index

...