mysql常用参数_mysql常用参数

[client]

port=5725

[mysql]

default-character-set=utf8

[mysqld]

# 设置5725端口

port=5725

# 设置mysql的安装目录

basedir=D:\\mysql725\\mysql-5.7.25-winx64

# 设置mysql数据库的数据的存放目录

datadir=D:\\mysql725\\mysql-5.7.25-winx64\\data

#影响mysql运行的重要参数

sql_mode ='NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

server_id=725

character-set-server=utf8

default-storage-engine=INNODB

local-infile=0

skip-external-locking

relay_log=mysql-relay-bin

log-bin=mysql-bin

binlog_format=row

binlog_row_image=full

relay_log_recovery=ON

relay_log_info_repository = TABLE

master_info_repository    = TABLE

log_slave_updates = ON

skip-slave-start=1

slave_preserve_commit_order=ON

sync_binlog=1

slave_parallel-type=LOGICAL_CLOCK

slave_parallel_workers=4

binlog_group_commit_sync_delay=10000

binlog_group_commit_sync_no_delay_count=20

innodb_strict_mode=0

default_authentication_plugin=mysql_native_password

max_connections=3000

key_buffer_size=512M

sort_buffer_size=1M

read_buffer_size=4M

join_buffer_size=8M

read_rnd_buffer_size=8M

max_allowed_packet=64M

table_open_cache=1024

tmp_table_size=256M

max_heap_table_size=256M

myisam_max_sort_file_size=64G

myisam_sort_buffer_size=128M

myisam_repair_threads=1

innodb_buffer_pool_size=512M

innodb_log_file_size=128M

innodb_log_buffer_size=16M

innodb_file_per_table=1

innodb_flush_log_at_trx_commit=1

innodb_lock_wait_timeout=50

event_scheduler=1

max_binlog_size=100M

init-file=D:/init.sql

log_bin_trust_function_creators = 1

[mysqldump]

quick

max_allowed_packet=16M

[mysql]

no-auto-rehash

[myisamchk]

key_buffer_size=80M

sort_buffer_size=80M

read_buffer=8M

write_buffer=8M

[mysqlhotcopy]

interactive-timeout