当前位置:Gxlcms > 数据库问题 > docker 安装配置mysql 5.7

docker 安装配置mysql 5.7

时间:2021-07-01 10:21:17 帮助过:5人阅读

//dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html [mysqld] # # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M skip-host-cache skip-name-resolve datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock secure-file-priv=/var/lib/mysql-files user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid default_storage_engine=InnoDB default-time-zone=+08:00 character-set-server=utf8mb4

4. 启动容器

docker run --name mysql57 --rm -p 3306:3306 -d -e MYSQL_ROOT_PASSWORD="123456" --mount type=bind,src=/opt/tsingyun/mysql57/my.cnf,dst=/etc/my.cnf --mount type=bind,src=/opt/tsingyun/mysql57/data,dst=/var/lib/mysql mysql/mysql-server:5.7

 

docker 安装配置mysql 5.7

标签:set   pool   ice   docke   ica   https   创建   file   ota   

人气教程排行