[mysqld] port = 3307 socket = /run/mysqld/mysqld.sock datadir = /var/lib/mysql-data/ tmpdir = /var/mytmp tmp_disk_table_size = 10737418240 #10G max_allowed_packet = 134217728 innodb_buffer_pool_size = 300G max_connections = 2048 thread_cache_size = 2048 innodb_print_all_deadlocks = 1 innodb_log_file_size = 16G innodb_io_capacity = 2000 innodb_flush_log_at_trx_commit = 2 transaction-isolation = 'READ-COMMITTED' slow_query_log slow_query_log_file = /var/log/mysql/mariadb-slow.log log_error = /var/log/mysql/mariadb-error.log open_files_limit = 65535 log_bin = /var/lib/mysql-binlogs/mysql-bin expire_logs_days = 7 max_binlog_size = 1000M binlog_format = ROW sync_binlog = 0 binlog_annotate_row_events=0 server_id = 6 skip-slave-start read_only = OFF slave_parallel_mode = CONSERVATIVE log_bin_trust_function_creators = ON log_slave_updates = ON relay_log = /var/lib/mysql-binlogs/relay-bin relay_log_space_limit = 100G sync_master_info = 0 sync_relay_log = 0 sync_relay_log_info=0 replicate_annotate_row_events=0 gtid_strict_mode = 1