[mysqld]

# server configuration
datadir=/home/hzwenzhh/innosql8/node1/data/
basedir=/home/hzwenzhh/innosql8/mysql/
socket=/home/hzwenzhh/innosql8/node1/mysql.sock
mysqlx_socket=/home/hzwenzhh/innosql8/node1/mysqlx.sock
plugin_dir=/home/hzwenzhh/innosql8/mysql/lib/plugin/
port=8001
mysqlx_port=8101

log_error_verbosity=3
binlog_rows_query_log_events=ON
innodb_print_all_deadlocks=OFF
explicit_defaults_for_timestamp=ON
server-id=1
innodb_thread_concurrency=0
innodb_strict_mode=ON
relay_log_recovery=ON
innodb_log_buffer_size=8388608
log_bin_trust_function_creators=OFF
character_set_server=utf8mb4
innodb_buffer_pool_dump_at_shutdown=ON
innodb_io_capacity=500
innodb_write_io_threads=4
log_slow_slave_statements=ON
gtid_mode=ON
table_definition_cache=1400
innodb_buffer_pool_dump_pct=40
wait_timeout=1800
log_slow_admin_statements=ON
innodb_adaptive_flushing=ON
performance_schema=ON
innodb_file_per_table
binlog_expire_logs_seconds=7200
innodb_flush_method=O_DIRECT
slave-parallel-type=LOGICAL_CLOCK
skip-slave-start
transaction-isolation=REPEATABLE-READ
innodb_page_cleaners=4
innodb_flush_log_at_trx_commit=1
interactive_timeout=1800
general_log=OFF
lower_case_table_names=0
master_info_repository=TABLE
log_queries_not_using_indexes=ON
long_query_time=5
slow_query_log=ON
innodb_change_buffering=all
log_bin=mysql-bin.log
max_binlog_size=100M
sync_binlog=1
relay-log=mysqld-relay-bin
relay_log_info_repository=TABLE
core-file
max_allowed_packet=16777216
innodb_log_file_size=4294967296
binlog_gtid_simple_recovery=TRUE
skip_external_locking
innodb_data_file_path=ibdata1:512M:autoextend
innodb_buffer_pool_load_at_startup=ON
skip-name-resolve
innodb_buffer_pool_instances=8
pid_file=mysql.pid
slave-parallel-workers=16
slow_query_log_file=mysql-slow.log
log_slave_updates=ON
innodb_read_io_threads=4
innodb_buffer_pool_size=20G
binlog_format=ROW
log_throttle_queries_not_using_indexes=0
min_examined_row_limit=100
innodb_old_blocks_time=1000
max_connections=3000
max_connect_errors=1000
innodb_lru_scan_depth=1024
innodb_buffer_pool_chunk_size=67108864
log_error=mysql-err.log
innodb_checksum_algorithm=crc32
binlog_checksum=NONE
innodb_io_capacity_max=8000
innodb_flush_neighbors=0
table_open_cache=2000
innodb_purge_threads=4
innodb_autoextend_increment=64
enforce_gtid_consistency=ON
autocommit=ON
log_timestamps=SYSTEM
innodb_lock_wait_timeout=5
user=mysql
slave_preserve_commit_order=ON