[mysqld] skip-name-resolve explicit_defaults_for_timestamp basedir=/opt/bitnami/mariadb plugin_dir=/opt/bitnami/mariadb/plugin port=3306 socket=/opt/bitnami/mariadb/tmp/mysql.sock tmpdir=/opt/bitnami/mariadb/tmp max_allowed_packet=2048M bind-address=* pid-file=/opt/bitnami/mariadb/tmp/mysqld.pid log-error=/opt/bitnami/mariadb/logs/mysqld.log character-set-server=UTF8 collation-server=utf8_general_ci slow_query_log=0 slow_query_log_file=/opt/bitnami/mariadb/logs/mysqld.log long_query_time=10.0 innodb_flush_method = nosync innodb_flush_log_at_trx_commit = 2 #key_buffer_size = 128M tmp_table_size = 256M max_connections = 2000 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 2M join_buffer_size = 2M thread_stack = 4M binlog_cache_size = 32M innodb_log_file_size = 256M skip-log-bin table_open_cache = 2048 innodb_flush_log_at_trx_commit = 0 innodb_buffer_pool_size = 58G innodb_read_io_threads=16 innodb_write_io_threads=8 key_buffer_size=3280M key_cache_block_size=8384 query_cache_type=1 join_buffer_size=1M sort_buffer_size=1M read_buffer_size=5M read_rnd_buffer_size=5M innodb_adaptive_hash_index=1 innodb_io_capacity=1500 query_cache_size=1G query_cache_limit=200M query_alloc_block_size=16384 innodb_table_locks=0 replicate-do-db=rsoc_eais_bo replicate-do-db=rsoc_nap_bo server-id = 25 log_bin = mysql-bin relay-log = relay-bin table_open_cache=16K table_definition_cache=16K tmp_table_size=2G max_heap_table_size=2G join_buffer_size=512K open_files_limit=200000 wait_timeout=14400 innodb_log_file_size=1892M optimizer_search_depth=0 innodb_flush_log_at_trx_commit = 2 join_buffer_size=2M sort_buffer_size=2M read_buffer_size=128K read_rnd_buffer_size=2M key_buffer_size=8192M innodb_strict_mode=0 plugin_load_add=mysql_json=type_mysql_json plugin_maturity=alpha replicate-wild-ignore-table = %.dic_users slave_run_triggers_for_rbr=YES skip-slave-start = TRUE [client] port=3306 socket=/opt/bitnami/mariadb/tmp/mysql.sock default-character-set=UTF8 plugin_dir=/opt/bitnami/mariadb/plugin [manager] port=3306 socket=/opt/bitnami/mariadb/tmp/mysql.sock pid-file=/opt/bitnami/mariadb/tmp/mysqld.pid