Sign inSign up

pterosaurs/mysql

By pterosaurs

•Updated over 3 years ago

Image
0

894

pterosaurs/mysql repository overview

⁠优化后mysql 配置

[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

⁠Dockerfile

FROM mysql:5.7.24
ADD my.conf /etc/my.conf

⁠root用户方式启动

docker run -d -p 3306:3306 -e MYSQL_ROOT_PASSWORD=mypass -v /root/mysql:/var/lib/mysql pterosaurs/mysql:5.7.24

Tag summary

Content type

Image

Digest

sha256:531745eda…

Size

148.3 MB

Last updated

over 3 years ago

docker pull pterosaurs/mysql