Shulou(Shulou.com)06/02 Report--

[client]

Port=3306

Socket=/u01/svr/run/mysql.sock

[mysql]

# pid_file=/u01/svr/run/mysqld.pid

[mysqld]

Autocommit=1

General_log=off

Explicit_defaults_for_timestamp=true

# system

Basedir=/u01/svr

Datadir=/u01/mydata

Max_allowed_packet=1g

Max_connections=3000

Max_user_connections=2800

Open_files_limit=65535

# pid_file=/u01/svr/run/mysqld.pid

Port=3306

Server_id=101

Skip_name_resolve=ON

Socket=/u01/svr/run/mysql.sock

Tmpdir=/u01/tmp

# binlog

Log_bin=/u01/logs/binlog/binlog

Binlog_cache_size=32768

Binlog_format=row

Expire_logs_days=7

Log_slave_updates=ON

Max_binlog_cache_size=2147483648

Max_binlog_size=524288000

Sync_binlog=100

# logging

Log_error=/u01/logs/error.log

Slow_query_log_file=/u01/logs/slow.log

Log_queries_not_using_indexes=0

Slow_query_log=1

Log_slave_updates=ON

Log_slow_admin_statements=1

Long_query_time=1

# relay

Relay_log=/u01/logs/relaylog

Relay_log_index=/u01/logs/relay.index

Relay_log_info_file=/u01/logs/relay-log.info

# slave

Slave_load_tmpdir=/u01/tmp

Slave_skip_errors=OFF

# innodb

Innodb_data_home_dir=/u01/logs/iblog

Innodb_log_group_home_dir=/u01/logs/iblog

Innodb_adaptive_flushing=ON

Innodb_adaptive_hash_index=ON

Innodb_autoinc_lock_mode=1

Innodb_buffer_pool_instances=8

# default

Innodb_change_buffering=inserts

Innodb_checksums=ON

Innodb_buffer_pool_size= 128M

Innodb_data_file_path=ibdata1:32M;ibdata2:16M:autoextend

Innodb_doublewrite=ON

Innodb_file_format=Barracuda

Innodb_file_per_table=ON

Innodb_flush_log_at_trx_commit=1

Innodb_flush_method=O_DIRECT

Innodb_io_capacity=1000

Innodb_lock_wait_timeout=10

Innodb_log_buffer_size=67108864

Innodb_log_file_size=1048576000

Innodb_log_files_in_group=4

Innodb_max_dirty_pages_pct=60

Innodb_open_files=60000

Innodb_purge_threads=1

Innodb_read_io_threads=4

Innodb_stats_on_metadata=OFF

Innodb_support_xa=ON

Innodb_use_native_aio=OFF

Innodb_write_io_threads=10

[mysqld_safe]

Datadir=/u01/mydata

-end

Good luck!

June 13, 2020

Changying in Chaoyang, Beijing

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.