mysql 5.6 生产my.cnf_一个生产可用的mysql参数文件my.cnf
[client]
#客戶端選項(xiàng)設(shè)置
#設(shè)置客戶端和連接字符集
default_character_set = utf8
port = 3306
socket = /opt/mysql-5.6.24/tmp/mysql.socket
[mysqld]
#服務(wù)器端選項(xiàng)設(shè)置
# innodb設(shè)置
default_storage_engine = InnoDB
innodb_strict_mode = 1
innodb_buffer_pool_size = 256M #mysql數(shù)據(jù)庫服務(wù)器，該值可設(shè)為物理內(nèi)存的50%-80%之間
innodb_stats_on_metadata = 0
innodb_file_format = Barracuda
innodb_data_file_path=ibdata1:10m:autoextend
innodb_flush_method = O_DIRECT
innodb_log_files_in_group = 2
innodb_log_file_size = 16M
innodb_log_buffer_size = 8M
innodb_file_per_table = 1
innodb_max_dirty_pages_pct = 60
innodb_io_capacity = 200
innodb_flush_log_at_trx_commit = 2
# 基本設(shè)置
basedir = /opt/mysql-5.6.24
datadir = /opt/mysql-5.6.24/data
port = 3306
tmpdir = /opt/mysql-5.6.24/tmp
socket = /opt/mysql-5.6.24/tmp/mysql.socket
pid-file = /opt/mysql-5.6.24/data/mysql.pid
skip-name-resolve = 1
skip-external-locking = 1
lower_case_table_names=1
#連接數(shù)設(shè)置
max_connect_errors = 500
max_connections = 1000
#mysql server打開文件限制
open_files_limit = 65535
#復(fù)制相關(guān)選項(xiàng)
server_id = 1553306
relay-log = mysql-relay-bin
log-slave-updates = 1
skip_slave_start = 1
read_only = 0
replicate-ignore-table = mysql.ibbackup_binlog_marker
slave-skip-errors = ddl_exist_errors
relay-log-info-repository = TABLE
master_info_repository = TABLE
relay_log_recovery = 1
plugin-load = "rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so"
gtid-mode = ON
enforce-gtid-consistency = 1
log-bin-trust-function-creators
#查詢緩存相關(guān)參數(shù)
query_cache_type = 0
query_cache_size = 0
# 服務(wù)器字符集設(shè)置
character_set_server = utf8
# error log設(shè)置
log_error = /opt/mysql-5.6.24/data/mysql.err
# slow log設(shè)置
slow_query_log = 1
slow_query_log_file = /opt/mysql-5.6.24/data/mysql-slow.log
long_query_time = 0.5
# binlog設(shè)置
binlog_format = mixed
log-bin = /opt/mysql-5.6.24/logs/mysql-bin
sync_binlog = 2
max_binlog_size = 16M
expire_logs_days = 10
#內(nèi)存設(shè)置
key_buffer_size = 8M
tmp_table_size = 8M
max_heap_table_size = 8M
thread_cache_size = 1024
table_open_cache = 1024
max_allowed_packet = 16M
join_buffer_size = 128M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
總結(jié)
以上是生活随笔為你收集整理的mysql 5.6 生产my.cnf_一个生产可用的mysql参数文件my.cnf的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。
