rds5632-dimitrik-60k.cnf

[mysqld]

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

# 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
#log-bin=master-bin
#loose-enable-performance-schema
basedir=/home/panfeng.zhou/RDS_5632
tmpdir=/home/panfeng.zhou/RDS_5632/mysql-test/var/tmp/mysqld.1
character-sets-dir=/home/panfeng.zhou/RDS_5632/sql/share/charsets
lc-messages-dir=/home/panfeng.zhou/RDS_5632/sql/share/
datadir=/home/panfeng.zhou/RDS_5632/mysql-test/var/mysqld.1/data
pid-file=/home/panfeng.zhou/RDS_5632/mysql-test/var/run/mysqld.1.pid
#host=localhost
port=15000
socket=/home/panfeng.zhou/RDS_5632/mysql-test/var/tmp/mysqld.1.sock
#log-error=/home/panfeng.zhou/RDS_5632/mysql-test/var/log/mysqld.1.err
#general_log=1
general_log_file=/home/panfeng.zhou/RDS_5632/mysql-test/var/mysqld.1/mysqld.log
#slow_query_log=1
slow_query_log_file=/home/panfeng.zhou/RDS_5632/mysql-test/var/mysqld.1/mysqld-slow.log
#user=root
#password=
server-id=1
secure-file-priv=/home/panfeng.zhou/RDS_5632/mysql-test/var
ssl-ca=/home/panfeng.zhou/RDS_5632/mysql-test/std_data/cacert.pem
ssl-cert=/home/panfeng.zhou/RDS_5632/mysql-test/std_data/server-cert.pem
ssl-key=/home/panfeng.zhou/RDS_5632/mysql-test/std_data/server-key.pem

[mysqlbinlog]
disable-force-if-open
character-sets-dir=/home/panfeng.zhou/RDS_5632/sql/share/charsets

[ENV]
MASTER_MYPORT=15000
MASTER_MYSOCK=/home/panfeng.zhou/RDS_5632/mysql-test/var/tmp/mysqld.1.sock

[client]
password=
user=root
port=15000
host=localhost
socket=/home/panfeng.zhou/RDS_5632/mysql-test/var/tmp/mysqld.1.sock

#[mysqltest]
#ssl-ca=/home/panfeng.zhou/RDS_5632/mysql-test/std_data/cacert.pem
#ssl-cert=/home/panfeng.zhou/RDS_5632/mysql-test/std_data/client-cert.pem
#ssl-key=/home/panfeng.zhou/RDS_5632/mysql-test/std_data/client-key.pem
#skip-ssl=1

[client.1]
password=
user=root
port=15000
host=localhost
socket=/home/panfeng.zhou/RDS_5632/mysql-test/var/tmp/mysqld.1.sock