MariaDB / mariadb-docker

Docker Official Image packaging for MariaDB
https://mariadb.org
GNU General Public License v2.0
759 stars 438 forks source link

How to set max_allowed_packet ? #467

Closed tgbv closed 1 year ago

tgbv commented 1 year ago

How do I specify the max_allowed_packet option? I tried the following docker-compose but it did not work:

version: '3.7'

services:
  mariadb:
    image: mariadb:10.9.3
    command: --max_allowed_packet=5GB
    volumes:
      - "./backend_db/mariadb.storage:/var/lib/mysql"
    ports:
      - "3306:3306"
    env_file: ./backend_db/mariadb.env

  adminer:
    image: adminer
    restart: always
    ports:
      - 8080:8080
grooverdan commented 1 year ago

1G maximum - https://mariadb.com/kb/en/server-system-variables/#max_allowed_packet