mysql5.56性能优化

#dvice on how to change settings please see

# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the

# *** default location during install, and will be replaced if you

# *** upgrade to a newer version of MySQL.

[mysqld]

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

basedir = /usr/local/mysql

datadir = /usr/local/mysql/data

port = 3306

socket = /tmp/mysql.sock

character-set-server=utf8

log-error = /usr/local/mysql/data/mysqld.log

pid-file = /usr/local/mysql/data/mysqld.pid

server-id=1

#innodb

innodb_buffer_pool_size=12G

innodb_log_file_size=256M

innodb_log_buffer_size=8M

innodb_flush_log_at_trx_commit=2

innodb_file_per_table=1

innodb_flush_method=O_DIRECT

innodb_io_capacity=2000

innodb_io_capacity_max=6000

innodb_lru_scan_depth=2000

innodb_thread_concurrency=0

innodb_autoinc_lock_mode = 2

innodb_log_files_in_group=3

#binlog

log-bin=mysql-bin

sync_binlog=1

sync_relay_log=1

relay-log-info-repository=TABLE

master-info-repository=TABLE

expire_logs_days=7

binlog_format=ROW

transaction-isolation=READ-COMMITTED

binlog_format=MIXED

#cache

tmp_table_size=512M

skip-external-locking

back_log=1024

key_buffer_size=1024M

thread_stack=256k

read_buffer_size=8M

thread_cache_size=64

query_cache_size=128M

max_heap_table_size=256M

query_cache_type=1

binlog_cache_size=2M

table_open_cache=128

wait_timeout=30

join_buffer_size = 1024M

sort_buffer_size = 8M

read_rnd_buffer_size = 8M

#connections

max-connect-errors=100000

max-connections=1000

explicit_defaults_for_timestamp=true