龙空技术网

mysql8.0部署,参数优化方案来了

alantop 182

前言:

此刻各位老铁们对“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参数优化