MySQL配置文件(/etc/my.cnf)

[client]
no-beep
#指定客户端登录时使用的socket，一定要指定对，要不不要指定
#socket = /tmp/mysql.sock
port = 3306

[mysql]
default-character-set=UTF8MB4

[mysqld]
#user=mysql
#bind=0.0.0.0
basedir=/usr/local/mysql
datadir=/data/mysql
log-error = /data/mysql/error.log
plugin_dir = /usr/local/mysql/lib/plugin
port=3306
pid-file=/tmp/mysql.pid
socket=/tmp/mysql.sock
#skip-grant-tables
skip-name-resolve
character-set-server=utf8
default-storage-engine=INNODB
server-id=1
max_connections=2000

#query_cache_size在8.0版本已经移除
#query_cache_size=0

table_open_cache=2000
tmp_table_size=246M
thread_cache_size=300
#限定用于每个数据库线程的栈大小。默认设置足以满足大多数应用
thread_stack = 192k
key_buffer_size=512M
read_buffer_size=4M
read_rnd_buffer_size=32M
innodb_data_home_dir = /data/mysql
innodb_flush_log_at_trx_commit=0
innodb_log_buffer_size=16M
innodb_buffer_pool_size=256M
innodb_log_file_size=128M
innodb_thread_concurrency=128
innodb_autoextend_increment=1000
innodb_buffer_pool_instances=8
innodb_concurrency_tickets=5000
innodb_old_blocks_time=1000
innodb_open_files=300
innodb_stats_on_metadata=0
innodb_file_per_table=1
innodb_checksum_algorithm=0
back_log=80
flush_time=0
join_buffer_size=128M
max_allowed_packet=1024M
max_connect_errors=2000
open_files_limit=4161

#query_cache_type在8.0版本已经移除，故注释
#query_cache_type=0

sort_buffer_size=32M
table_definition_cache=1400
binlog_row_event_max_size=8K
sync_master_info=10000
sync_relay_log=10000
sync_relay_log_info=10000
#批量插入数据缓存大小，可以有效提高插入效率，默认为8M
bulk_insert_buffer_size = 64M
interactive_timeout = 120
wait_timeout = 120
log-bin-trust-function-creators=1
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES