my.conf

my.conf

配置文件生成工具参考链接：https://imysql.com/my_cnf_generator

[client]
#password=your_password
port=3306
socket=/tmp/mysql.sock
default-character-set=utf8mb4

[mysql]
no-auto-rehash
prompt="\\\r:\\\m:\\\s(\\\u@\\\h) [\\\d]>\\\_"

[mysqld]
port=3306
socket=/tmp/mysql.sock
basedir=${install_dir}
datadir=${data_dir}
pid-file=${data_dir}/mysql.pid
user=${user}
bind-address=0.0.0.0
server-id=1

init-connect='SET NAMES utf8mb4'
character-set-server=utf8mb4

# 跳过NDS解析
skip-name-resolve
#skip-networking
back_log=300

max_connections=1000
max_connect_errors=6000
open_files_limit=65535
table_open_cache=128
max_allowed_packet=500M
binlog_cache_size=1M
max_heap_table_size=8M
tmp_table_size=16M

read_buffer_size=2M
read_rnd_buffer_size=8M
sort_buffer_size=8M
net_buffer_length=8K
join_buffer_size=8M
key_buffer_size=4M
performance_schema_max_table_instances=500

thread_cache_size=8

ft_min_word_len=4

log_bin=mysql-bin
binlog_format=mixed
expire_logs_days=7

log_error=${data_dir}/mysql-error.log
slow_query_log=1
long_query_time=1
slow_query_log_file=${data_dir}/mysql-slow.log

performance_schema=0
explicit_defaults_for_timestamp

#lower_case_table_names=1

skip-external-locking

default_storage_engine=InnoDB
#default-storage-engine=MyISAM
innodb_file_per_table=1  # 开启独立表空间
innodb_data_home_dir=${data_dir}
innodb_data_file_path=ibdata1:12M:autoextend
innodb_log_group_home_dir=${data_dir}
innodb_open_files=500
innodb_buffer_pool_size=64M
innodb_write_io_threads=4
innodb_read_io_threads=4
innodb_thread_concurrency=0
innodb_purge_threads=1
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=2M
innodb_log_file_size=32M
innodb_log_files_in_group=3
innodb_max_dirty_pages_pct=90
innodb_lock_wait_timeout=120 # 事务锁超时时长

bulk_insert_buffer_size=8M
myisam_sort_buffer_size=8M
myisam_max_sort_file_size=10G
myisam_repair_threads=1

# 这个参数对于后端连接毫无作用，什么是interactive？是你拿着键盘在mysql命令行下敲select, 这个叫interactive
interactive_timeout=28800
wait_timeout=28800

[mysqldump]
quick
max_allowed_packet=500M

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