[client]

客户端设置

port = 3306
socket = /data/mysql/data/mysql.sock
default-character-set = utf8mb4

[mysqld]
user = mysql
port = 3306
socket = /data/mysql/data/mysql.sock
server-id = 1
pid-file = /data/mysql/data/mysql.pid

安装目录

basedir = /usr/local/mysql

数据库存放目录

datadir = /data/mysql/data/

系统数据库编码设置，排序规则

character_set_server = utf8mb4
collation_server = utf8mb4_bin
back_log = 1024
explicit_defaults_for_timestamp = ON
lower_case_table_names = 0
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

max_connections = 512
max_connect_errors = 1000000
table_open_cache = 1024
max_allowed_packet = 8M
thread_stack = 256K
thread_cache_size = 384

skip-external-locking

interactive_timeout = 600
wait_timeout = 3600
log_timestamps = SYSTEM
log-error = /data/mysql/logs/error.log

默认使用InnoDB存储引擎

default_storage_engine = InnoDB
innodb_buffer_pool_size = 64M
innodb_purge_threads = 1
innodb_log_buffer_size = 2M
innodb_log_file_size = 128M
innodb_lock_wait_timeout = 120

bulk_insert_buffer_size = 32M
myisam_sort_buffer_size = 8M

MySQL重建索引时所允许的最大临时文件的大小

myisam_max_sort_file_size = 10G
myisam_repair_threads = 1
lower_case_table_names=1

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M
read_buffer = 4M
write_buffer = 4M