performance_schema = ON tmpdir = /run/mariadb thread_cache_size = 4 table_open_cache = 16384 table_definition_cache = 8384 sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION query_cache_type = 0 query_cache_size = 0 query_cache_limit = 128M query_cache_strip_comments = 1 tmp_table_size = 512M max_heap_table_size = 512M max_connections = 750 max_allowed_packet = 24M sort_buffer_size = 24M join_buffer_size = 48M innodb_buffer_pool_size = 65G # 65-75% of RAM for InnoDB cache --> Keeping some for VUE innodb_buffer_pool_instances = 10 # One instance per CPU core --> Keeping some for VUE innodb_flush_method = O_DIRECT # Reduce I/O overhead innodb_flush_log_at_trx_commit = 2 # Balance performance and durability innodb_log_buffer_size = 16M # Buffer for transaction logs innodb_thread_concurrency = 0 # Let MySQL manage threads (0 = unlimited) innodb_io_capacity = 2000 # Adjust based on storage IOPS innodb_io_capacity_max = 4000 # Max IOPS for bursts innodb_use_native_aio = 1 innodb_flush_log_at_trx_commit = 2 # Balance performance and durability --> Changed from 0 innodb_file_per_table innodb_log_file_size = 2G # Larger logs for better write performance --> Changed from 512