[mysqld] innodb_strict_mode = ON innodb_buffer_pool_size = 100G innodb_file_per_table = ON innodb_flush_method = O_DIRECT innodb_log_files_in_group = 2 innodb_log_file_size = 512M innodb_log_buffer_size = 128M innodb_flush_log_at_trx_commit = 2 #innodb_adaptive_hash_index = OFF #innodb_thread_concurrency = 32 #innodb_write_io_threads = 32 #innodb_read_io_threads = 32 #innodb_io_capacity = 20000 #innodb_flush_neighbors = 0 #innodb_lru_scan_depth = 20000 max_connections = 500 max_allowed_packet = 1G tmp_table_size = 1G max_heap_table_size = 1G #disable_log_bin log_bin = redacted binlog_format = ROW binlog_do_db = redacted server_id = redacted binlog_expire_logs_seconds = 604800 sync_binlog = 1 log_output = TABLE #slow_query_log = ON default_authentication_plugin = mysql_native_password skip_name_resolve port = redacted mysqlx_port = redacted datadir = redacted socket = redacted mysqlx_socket = redacted log_error = redacted pid_file = redacted character_set_server = latin1 collation_server = latin1_swedish_ci [mysqldump] max_allowed_packet = 1G