mysql5.7配置文件

datadir=/data/mysql
socket=/var/lib/mysql/mysql.sock

Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

log-error=/data/mysql/mysqld.log
pid-file=/data/mysql/mysqld/mysqld.pid
default-time-zone = '+8:00'
max_connections = 1000
lower_case_table_names=1
max_allowed_packet=1024M
default-storage-engine=INNODB
character-set-server=utf8
collation-server=utf8_general_ci
open_files_limit = 65535
back_log = 1024
table_open_cache = 1024
table_definition_cache = 1024
table_open_cache_instances = 64
thread_stack = 512K
external-locking = FALSE

sort_buffer_size = 4M
join_buffer_size = 4M
thread_cache_size = 3000
interactive_timeout = 600
wait_timeout = 600
tmp_table_size = 32M
max_heap_table_size = 32M
slow_query_log = 1
log_timestamps = SYSTEM
slow_query_log_file = /data/mysql/slow.log
long_query_time = 0.1
log_queries_not_using_indexes =1
log_throttle_queries_not_using_indexes = 60
min_examined_row_limit = 100

innodb_buffer_pool_size = 48G
innodb_buffer_pool_instances = 4
innodb_buffer_pool_load_at_startup = 1
innodb_buffer_pool_dump_at_shutdown = 1