polar56-dimitrik-110k.cnf

[mysqld]
## Replication account info. Note, user_name will always be 'replicator' and user_password will be generated by control system randomly. All replica will use this account to build replication. Different PolarDB cluster(means one primary with multiple replicas) will have different user_passwordl.
loose_polar_master_user_name = replicator
loose_polar_master_user_password = 22192219
loose_polar_master_port = 7250
loose_polar_master_host = 127.0.0.1

## Variable needed by PolarFS, every role in one specified PolarDB cluster must have unique value.
loose_polarfs_host_id = 1
skip-log-bin
port=7250
innodb_polar_log_file_extend_method=0

# general
max_connections=4000
table_open_cache=8000
table_open_cache_instances=16
back_log=1500
#default_password_lifetime=0
ssl=0
performance_schema=OFF
max_prepared_stmt_count=512000
skip_log_bin=1
character_set_server=latin1
collation_server=latin1_swedish_ci
transaction_isolation=REPEATABLE-READ

# files
innodb_file_per_table
innodb_log_file_size=1024M
innodb_log_files_in_group=3
innodb_open_files=4000

# buffers
innodb_buffer_pool_size=32000M
innodb_buffer_pool_instances=16
innodb_log_buffer_size=64M

# tune
innodb_doublewrite=0
innodb_thread_concurrency=0
innodb_flush_log_at_trx_commit=1
innodb_max_dirty_pages_pct=90
innodb_max_dirty_pages_pct_lwm=10

join_buffer_size=32K
sort_buffer_size=32K
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_NO_FSYNC
innodb_checksum_algorithm=crc32
innodb_io_capacity=4000
innodb_io_capacity_max=20000
innodb_lru_scan_depth=9000
innodb_change_buffering=none
innodb_read_only=0
innodb_page_cleaners=4
innodb_undo_log_truncate=off

# perf special
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

# monitoring
innodb_monitor_enable='%'

performance_schema = OFF

[mysql]
default-character-set=latin1

[mysqlshow]
default-character-set=latin1

[mysqlimport]
default-character-set=latin1

[mysqlcheck]
default-character-set=latin1

[mysql_upgrade]
default-character-set=latin1
tmpdir=/disk12/xin/polardb/bu/mysql-test/var/tmp

[mysqld.1]
#!run-master-sh
#1 log-bin=master-bin
#2 loose-enable-performance-schema
basedir=/disk12/xin/polardb/bu
tmpdir=/disk12/xin/polardb/bu/mysql-test/var/tmp/mysqld.1
character-sets-dir=/disk12/xin/polardb/bu/share/charsets
lc-messages-dir=/disk12/xin/polardb/bu/share/
datadir=/disk12/xin/polardb/bu/mysql-test/var/mysqld.1/data
polar_node_basedir=/disk12/xin/polardb/bu/mysql-test/var/mysqld.1/data
pid-file=/disk12/xin/polardb/bu/mysql-test/var/run/mysqld.1.pid
#host=localhost
port=15000
socket=/disk12/xin/polardb/bu/mysql-test/var/tmp/mysqld.1.sock
#log-error=/disk12/xin/polardb/bu/mysql-test/var/log/mysqld.1.err
#general_log=1
general_log_file=/disk12/xin/polardb/bu/mysql-test/var/mysqld.1/mysqld.log
#4 slow_query_log=1
slow_query_log_file=/disk12/xin/polardb/bu/mysql-test/var/mysqld.1/mysqld-slow.log
#user=root
#password=
server-id=1
secure-file-priv=/disk12/xin/polardb/bu/mysql-test/var
ssl-ca=/disk12/xin/polardb/bu/mysql-test/std_data/cacert.pem
ssl-cert=/disk12/xin/polardb/bu/mysql-test/std_data/server-cert.pem
ssl-key=/disk12/xin/polardb/bu/mysql-test/std_data/server-key.pem

# [mysqlbinlog]
#5 disable-force-if-open
#6 character-sets-dir=/disk12/xin/polardb/bu/share/charsets

[ENV]
MASTER_MYPORT=15000
MASTER_MYSOCK=/disk12/xin/polardb/bu/mysql-test/var/tmp/mysqld.1.sock

[client]
password=
user=root
port=15000
host=localhost
socket=/disk12/xin/polardb/bu/mysql-test/var/tmp/mysqld.1.sock

# [mysqltest]
#ssl-ca=/disk12/xin/polardb/bu/mysql-test/std_data/cacert.pem
#ssl-cert=/disk12/xin/polardb/bu/mysql-test/std_data/client-cert.pem
#ssl-key=/disk12/xin/polardb/bu/mysql-test/std_data/client-key.pem
#skip-ssl=1

[client.1]
password=
user=root
port=15000
host=localhost
socket=/disk12/xin/polardb/bu/mysql-test/var/tmp/mysqld.1.sock