前言:
此刻各位老铁们对“mysql部署方案”可能比较珍视,你们都想要学习一些“mysql部署方案”的相关文章。那么小编在网络上收集了一些关于“mysql部署方案””的相关资讯,希望你们能喜欢,咱们一起来了解一下吧!mysql 8.0 部署,参数优化方案
[client]
default-character-set = utf8
[mysqld]
port = 3306
default-storage-engine = INNODB
character-set-server = utf8
collation-server = utf8_bin
max_connections = 1024
max_allowed_packet = 64M
lower_case_table_names = 1
innodb_buffer_pool_size = 30G
innodb_buffer_pool_instances = 10
join_buffer_size = 256M
read_rnd_buffer_size = 16M
read_buffer_size = 16M
sort_buffer_size = 16M
open_files_limit = 65535
innodb_read_io_threads = 20
innodb_write_io_threads = 16
innodb_thread_concurrency = 0
innodb_flush_log_at_trx_commit = 2
binlog_format = mixed
tmp_table_size = 256M
max_heap_table_size = 256M
thread_cache_size = 64
disable-log-bin
log_slave_updates = 0
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
pid-file=/var/run/mysqld/mysqld.pid
标签: #mysql部署方案 #mysql8参数优化