一、初级配置,能用即可
[mysql]
default-character-set=utf8
[mysqld]
port = 3306
basedir=C:\Program Files\MySQL
datadir=C:\Program Files\MySQL\data
max_connections=1000
character-set-server=utf8
default-storage-engine=INNODB
group_concat_max_len=102400
default-time-zone='+08:00'
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
lower_case_table_names=1
二、简单升级配置
[mysql]
default-character-set=utf8
[mysqld]
port=3306
basedir=D:\\mysql-5.7.26-winx64
datadir=D:\\mysql-5.7.26-winx64\\data
max_connections=3000
character-set-server=utf8
default-storage-engine=INNODB
max_allowed_packet=32M
max_heap_table_size=8192M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
lower_case_table_names=1
default-time-zone='+08:00'
slow_query_log
long_query_time=5
log-queries-not-using-indexes
tmp_table_size=256M
myisam_sort_buffer_size=512M
key_buffer_size=128M
bulk_insert_buffer_size=256M
myisam_sort_buffer_size=256M
myisam_max_sort_file_size=10G
myisam_repair_threads=1
read_buffer_size=32M
read_rnd_buffer_size=64M
sort_buffer_size=32M
join_buffer_size=32M
query_cache_size=512M
query_cache_limit=16M
key_buffer_size=512M
max_allowed_packet=64M
table_open_cache=4096