[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
default-character-set=utf8mb4
[mysqld]
port = 3306
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
datadir = /var/lib/mysql
wait_timeout=1000
symbolic-links=0
interactive_timeout=1000
max-connect-errors=100000
max-connections=2000
innodb_flush_method=O_DIRECT
skip-name-resolve
innodb_buffer_pool_size = 8000M
innodb_log_buffer_size = 64M
innodb_log_file_size = 256M
skip-external-locking
key_buffer_size = 2000M
max_allowed_packet = 16M
table_open_cache = 256
sort_buffer_size = 1024K
net_buffer_length = 32K
read_buffer_size = 512K
read_rnd_buffer_size = 1024K
myisam_sort_buffer_size = 16M
slow_query_log=1
thread_cache_size=32
long_query_time=2
local-infile=0
log-bin=mysql-bin
binlog_format=mixed
server-id = 10
character_set_server=utf8
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
skip-character-set-client-handshake = 1
character_set_server = utf8mb4
collation_server = utf8mb4_general_ci
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
default-character-set = utf8mb4
max_allowed_packet = 16M
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
FROM mysql:5.7.24
ADD my.conf /etc/my.conf
docker run -d -p 3306:3306 -e MYSQL_ROOT_PASSWORD=mypass -v /root/mysql:/var/lib/mysql pterosaurs/mysql:5.7.24
Content type
Image
Digest
sha256:531745eda…
Size
148.3 MB
Last updated
over 3 years ago
docker pull pterosaurs/mysql