my.ini配置文件

[client]

port=3306

[mysql]
no-beep

default-character-set=utf8

server_type=3

[mysqld]

port=3306

datadir=E:/ProgramData/MySQL/MySQL Server 5.7/Data

datadir=F:\ProgramData\Data

default-storage-engine=INNODB

Set the SQL mode to strict

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

character-set-server=utf8

log_bin_trust_function_creators=1

transaction-isolation=READ-COMMITTED

General and Slow logging.

log-output=FILE

general-log=0

general_log_file="HOST-0002.log"

slow-query-log=1

slow_query_log_file="HOST-0002-slow.log"

long_query_time=10

log-error="F:\ProgramData\HOST-0002.err"

relay_log="HOST-0002-relay"

server-id=1

report_port=3306

lower_case_table_names=1

Secure File Priv.

secure-file-priv="E:/ProgramData/MySQL/MySQL Server 5.7/Uploads"

max_connections=10000

table_open_cache=2048

tmp_table_size=2G

thread_cache_size=300

myisam_max_sort_file_size=100G

myisam_sort_buffer_size=209M

key_buffer_size=512M

read_buffer_size=20M

read_rnd_buffer_size=8M

*** INNODB Specific options ***

innodb_data_home_dir=

innodb_flush_log_at_trx_commit=2

innodb_log_buffer_size=1M

innodb_log_file_size=48M

innodb_thread_concurrency=17

innodb_autoextend_increment=64

innodb_buffer_pool_instances=16

innodb_buffer_pool_size=20G

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=512M

max_allowed_packet=500M

max_connect_errors=100

open_files_limit=4161

sort_buffer_size=1024M

table_definition_cache=400

binlog_row_event_max_size=8K

sync_master_info=10000

sync_relay_log=10000
sync_relay_log_info=10000

event_scheduler=ON