This option file will allow connections from any interface. Binary logs, transaction logs, undo files, and data files will be stored in separate locations. The innodb_page_size will be set to 16K and the 32Gb buffer pool will be divided into 16 separate instances.
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
[mysqld]
# Server Management
bind-address = 0.0.0.0
port = 3306
socket=/var/lib/mysql/mysql.sock
max_connections = 4000
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
back_log = 1500
table_open_cache=8000
table_open_cache_instances=16
max_prepared_stmt_count=512000
# Data and log management
basedir = /mysql/base
datadir = /mysql/base/data
innodb_data_home_dir = /mysql/base/data
innodb_data_file_path = ibdata1:12M:autoextend
innodb_log_group_home_dir = /mysql/log
innodb_undo_directory = /mysql/undo
log-bin = /mysql/binlog/binlog
# innodb settings
innodb_page_size = 16K
innodb_buffer_pool_size=32G
innodb_buffer_pool_instances=16
innodb_log_buffer_size=32M
innodb_file_per_table
innodb_log_file_size=1024M
innodb_log_files_in_group=32
innodb_open_files=4000
innodb_log_compressed_pages=off
innodb_doublewrite=ON
innodb_thread_concurrency=0
innodb_flush_log_at_trx_commit=1
innodb_max_dirty_pages_pct=90
innodb_max_dirty_pages_pct_lwm=10
innodb_use_native_aio=1
innodb_stats_persistent=1
innodb_spin_wait_delay=6
innodb_max_purge_lag_delay=300000
innodb_max_purge_lag=0
innodb_flush_method=O_DIRECT
innodb_checksum_algorithm=crc32
innodb_io_capacity=1000
innodb_io_capacity_max=3000
innodb_lru_scan_depth=9000
innodb_change_buffering=none
innodb_read_only=0
innodb_page_cleaners=4
innodb_undo_log_truncate=off
innodb_adaptive_flushing=1
innodb_flush_neighbors=0
innodb_read_io_threads=16
innodb_write_io_threads=16
innodb_purge_threads=4
innodb_adaptive_hash_index=0
innodb_monitor_enable='%'
# Error Message files
# lc_messages_dir = /mysql/lcmessages
# lc_messages = en_US
#other
binlog_expire_logs_seconds=300