mysql 优化之后的配置

[client]
port            = 3306
socket          = /tmp/mysql.sock
secure_auth    = false

[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
datadir        = /data
#read_only      = on

#--- GLOBAL ---#
character_set_server    = utf8
lower_case_table_names  = 1
log-output              = FILE
log-error              = /tmp/logs/mysql-error.log
#general_log
general_log_file        = /tmp/logs/mysql.log
pid-file                = /data/mysql.pid
slow-query-log          = 1
slow_query_log_file    = /tmp/logs/mysql-slow.log
tmpdir                  = /tmp/
long_query_time        = 2
innodb_force_recovery  = 0
#innodb_buffer_pool_dump_at_shutdown = 1
#innodb_buffer_pool_load_at_startup = 1
#--------------#

#thread_concurrency      = 8 
thread_cache_size      = 51 
table_open_cache        = 16384
open_files_limit        = 65535
table_definition_cache  = 16384
sort_buffer_size        = 2M
join_buffer_size        = 2M
read_buffer_size        = 2M
read_rnd_buffer_size    = 8M
key_buffer_size        = 32M
bulk_insert_buffer_size = 16M
myisam_sort_buffer_size = 64M
tmp_table_size          = 32M
max_heap_table_size    = 16M
query_cache_size      = 32MB

#gtid_mode=on
#log_slave_updates=1
#enforce_gtid_consistency=1

#--- NETWORK ---#
back_log                = 103
max-connections        = 512
max_connect_errors    = 100000
max_allowed_packet      = 32M
interactive_timeout    = 600
wait_timeout            = 600
skip-external-locking
#max_user_connections    = 0
external-locking        = FALSE
#skip-name-resolve

#--- REPL ---#
server-id              = 28703306
sync_binlog            = 1
log-bin                = mysql-bin
binlog_format          = row
expire_logs_days        = 10
relay-log              = relay-log
replicate-ignore-db    = test
log_slave_updates      =1
#skip-slave-start
binlog_cache_size      =4M
max_binlog_cache_size  =8M
max_binlog_size        =1024M
log_bin_trust_function_creators=1

#--- INNODB ---#
default_storage_engine          = InnoDB
innodb_data_file_path          = ibdata1:1024M:autoextend
innodb_buffer_pool_size        = 1040M
innodb_buffer_pool_instances    = 1
innodb_additional_mem_pool_size = 16M
innodb_log_files_in_group      = 2
innodb_log_file_size            = 256MB
innodb_log_buffer_size          = 16M
innodb_flush_log_at_trx_commit  = 2
innodb_lock_wait_timeout        = 30
innodb_flush_method            = O_DIRECT
innodb_max_dirty_pages_pct      = 75
innodb_io_capacity              = 200
innodb_thread_concurrency      = 32
innodb_open_files              = 65535
innodb_file_per_table          = 1
transaction_isolation          = REPEATABLE-READ
innodb_locks_unsafe_for_binlog  = 0
#innodb_purge_thread            = 4
skip_name_resolve              = 1
[mysqldump]
quick
max_allowed_packet = 32M

[mysql]
auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
default_character_set=utf8

[mysqlhotcopy]
interactive-timeout