mysql8配置文件优化_2018_lcf

版本一

[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql

# 日志相关
slow_query_log=ON
log_error ="/var/lib/mysql/log/error.log"
slow_query_log_file="/var/lib/mysql/log/blg-slow.log"
long_query_time=2
log_queries_not_using_indexes = 1
log_throttle_queries_not_using_indexes = 10
expire_logs_days = 90
min_examined_row_limit = 100
log_output=TABLE,FILE
general_log=1

# binlog设置 
master_info_repository = TABLE
relay_log_info_repository = TABLE
log_bin = bin.log
server-id=150

# innodb 设置
default_storage_engine = InnoDB
innodb_file_per_table = 1
innodb_open_files = 500
innodb_buffer_pool_size = 1024M
innodb_write_io_threads = 4
innodb_read_io_threads = 4
innodb_thread_concurrency = 0
innodb_purge_threads = 1
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size &#