jiangjiali/mysql repository overview

  mysql:
    image: jiangjiali/mysql:8.0.37.1
    restart: always
    container_name: mysql
    command:
      --default-authentication-plugin=mysql_native_password
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
      --explicit_defaults_for_timestamp=true
      --lower_case_table_names=1
      --default-time-zone=+8:00
    environment:
      - MYSQL_ROOT_PASSWORD=密码
    volumes:
      - ./docker/mysql/my.cnf:/etc/my.cnf:ro
      - ./docker/mysql/data:/var/lib/mysql:rw
      - /etc/localtime:/etc/localtime
    ports:
      - "8306:3306"
    networks:
      hx_net:
        ipv4_address: 11.11.11.12

[mysqld]
user=mysql
port=3306
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
default-storage-engine=INNODB
character-set-server=utf8mb4
skip_name_resolve=1
default_time_zone="+8:00"
default_authentication_plugin=mysql_native_password
ngram_token_size = 2

# performance setttings
open_files_limit=65535
performance_schema=off
performance_schema_max_table_instances=150
table_definition_cache=150
table_open_cache=64
max_connections=150
max_connect_errors=10
wait_timeout=600

# innodb settings
innodb_buffer_pool_size=5242880
innodb_buffer_pool_instances=4
innodb_flush_log_at_trx_commit=0
innodb_flush_method=O_DIRECT
innodb_stats_persistent_sample_pages=500
innodb_lock_wait_timeout=10
innodb_thread_concurrency=8
innodb_autoextend_increment=16
innodb_concurrency_tickets=1024
innodb_old_blocks_time=1000
innodb_open_files=65535
innodb_stats_on_metadata=0
innodb_file_per_table=1

[client]
port=3306
socket=/var/lib/mysql/mysql.sock
default-character-set=utf8mb4

[mysql]
no_auto_rehash
loose-skip-binary-as-hex
default-character-set=utf8mb4

[mysqldump]
quick