github.com/1aal/kubeblocks@v0.0.0-20231107070852-e1c03e598921/test/testdata/cue_testdata/wesql.cnf (about)

     1  [mysqld]
     2  # aliyun buffer pool: https://help.aliyun.com/document_detail/162326.html?utm_content=g_1000230851&spm=5176.20966629.toubu.3.f2991ddcpxxvD1#title-rey-j7j-4dt
     3  
     4  # require port
     5  
     6  # alias replica_exec_mode. Aliyn slave_exec_mode=STRICT
     7  slave_exec_mode=IDEMPOTENT
     8  
     9  # gtid   WeSQL Consensus set
    10  # AWS OFF_PERMISSIVE
    11  gtid_mode=ON
    12  enforce_gtid_consistency=ON
    13  
    14  # consensus
    15  loose_consensus_enabled=ON
    16  loose_consensus_io_thread_cnt=8
    17  loose_consensus_worker_thread_cnt=8
    18  loose_consensus_election_timeout=1000
    19  loose_consensus_auto_leader_transfer=OFF
    20  loose_consensus_prefetch_window_size=100
    21  loose_consensus_auto_reset_match_index=ON
    22  loose_cluster_mts_recover_use_index=ON
    23  # loose_replicate_same_server_id=ON
    24  loose_consensus_large_trx=ON
    25  loose_consensuslog_revise=ON
    26  # loose_cluster_log_type_node=OFF
    27  
    28  #server & instances
    29  thread_stack=262144
    30  thread_cache_size=60
    31  # ulimit -n
    32  open_files_limit=1048576
    33  local_infile=ON
    34  persisted_globals_load=OFF
    35  sql_mode=NO_ENGINE_SUBSTITUTION
    36  #Default 4000
    37  table_open_cache=4000
    38  
    39  # under high number thread (such as 128 threads), this value will cause sysbench fails
    40  # if so, change it to 100000 or higher.
    41  max_prepared_stmt_count=16382
    42  
    43  innodb_buffer_pool_size=1024M
    44  
    45  performance_schema_digests_size=10000
    46  performance_schema_events_stages_history_long_size=10000
    47  performance_schema_events_transactions_history_long_size=10000
    48  read_buffer_size=262144
    49  read_rnd_buffer_size=524288
    50  join_buffer_size=262144
    51  sort_buffer_size=262144
    52  
    53  #default_authentication_plugin=mysql_native_password    #From mysql8.0.23 is deprecated.
    54  authentication_policy=mysql_native_password,
    55  back_log=5285
    56  host_cache_size=867
    57  connect_timeout=10
    58  
    59  # character-sets-dir=/usr/share/mysql-8.0/charsets
    60  
    61  port=3306
    62  mysqlx-port=33060
    63  mysqlx=0
    64  
    65  datadir=/data/mysql/data
    66  
    67  log_statements_unsafe_for_binlog=OFF
    68  log_error_verbosity=2
    69  log_output=FILE
    70  # Mysql error log
    71  log_error=/data/mysql/log/mysqld-error.log
    72  # MySQL Slow log
    73  slow_query_log=ON
    74  long_query_time=5
    75  slow_query_log_file=/data/mysql/log/mysqld-slowquery.log
    76  
    77  #innodb
    78  innodb_doublewrite_batch_size=16
    79  innodb_doublewrite_pages=32
    80  innodb_flush_method=O_DIRECT
    81  innodb_io_capacity=200
    82  innodb_io_capacity_max=2000
    83  innodb_log_buffer_size=8388608
    84  #innodb_log_file_size and innodb_log_files_in_group are deprecated in MySQL 8.0.30. These variables are superseded by innodb_redo_log_capacity. 
    85  #innodb_log_file_size=134217728
    86  #innodb_log_files_in_group=2
    87  innodb_redo_log_capacity=268435456
    88  innodb_open_files=4000
    89  innodb_purge_threads=1
    90  innodb_read_io_threads=4
    91  # innodb_print_all_deadlocks=ON    # AWS not set
    92  key_buffer_size=16777216
    93  
    94  # binlog
    95  # master_info_repository=TABLE
    96  # From mysql8.0.23 is deprecated.
    97  binlog_cache_size=32768
    98  # AWS binlog_format=MIXED, Aliyun is ROW
    99  binlog_format=MIXED
   100  binlog_row_image=FULL
   101  # Aliyun AWS binlog_order_commits=ON
   102  binlog_order_commits=ON
   103  log-bin=mysql-bin
   104  log_bin_index=mysql-bin.index
   105  max_binlog_size=134217728
   106  log_replica_updates=1
   107  # binlog_rows_query_log_events=ON #AWS not set
   108  # binlog_transaction_dependency_tracking=WRITESET    #Default Commit Order, Aws not set
   109  
   110  # replay log
   111  # relay_log_info_repository=TABLE
   112  # From mysql8.0.23 is deprecated.
   113  relay_log_recovery=ON
   114  relay_log=relay-bin
   115  relay_log_index=relay-bin.index
   116  
   117  pid-file=/var/run/mysqld/mysqld.pid
   118  socket=/var/run/mysqld/mysqld.sock
   119  
   120  [client]
   121  port=3306
   122  socket=/var/run/mysqld/mysqld.sock