# repricer-specific settings (read after ~/infra/mysql/common.cnf and override it). # Database ~160 GB, heavy analytical queries. Host: 32 threads, 61 GB RAM, NVMe. [mysqld] # Same as prod character-set-server = utf8mb4 collation-server = utf8mb4_0900_ai_ci sql_mode = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION default-time-zone = '+00:00' skip-name-resolve # Memory innodb_buffer_pool_size = 24G innodb_buffer_pool_instances = 8 innodb_log_buffer_size = 256M innodb_redo_log_capacity = 8G tmp_table_size = 1G max_heap_table_size = 1G temptable_max_ram = 4G sort_buffer_size = 8M join_buffer_size = 8M read_rnd_buffer_size = 4M # Disk / threads innodb_io_capacity = 4000 innodb_io_capacity_max = 10000 innodb_read_io_threads = 16 innodb_write_io_threads = 16 innodb_parallel_read_threads = 8 innodb_ddl_threads = 8 innodb_ddl_buffer_size = 1G innodb_sort_buffer_size = 64M innodb_file_per_table = ON innodb_autoinc_lock_mode = 2 # Connections and long queries max_connections = 200 table_open_cache = 4000 open_files_limit = 65535 wait_timeout = 28800 interactive_timeout = 28800 net_read_timeout = 600 net_write_timeout = 600 innodb_lock_wait_timeout = 600