mariadb/mysql server.conf

50-server.conf

###############
# 88CPUs 128GB
###############
# MariaDB Configuration File

# Server
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Logging
log_error=/var/log/mysql/error.log
general_log=0
general_log_file=/var/log/mysql/mysql.log

# MyISAM
key_buffer_size = 256M
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 10G
myisam_repair_threads = 4

# InnoDB
innodb_buffer_pool_size = 96G
innodb_log_file_size = 4G
innodb_log_buffer_size = 512M
innodb_file_per_table = 1
innodb_open_files = 5000
innodb_io_capacity = 2000
innodb_io_capacity_max = 4000
innodb_flush_method = O_DIRECT

# Connection
max_connections = 2000
max_allowed_packet = 512M
wait_timeout = 28800
interactive_timeout = 28800

# Query Cache (Disabled)
query_cache_type = 0
query_cache_size = 0

# Performance
thread_cache_size = 100
tmp_table_size = 256M
max_heap_table_size = 256M
join_buffer_size = 16M
read_buffer_size = 16M
read_rnd_buffer_size = 8M
sort_buffer_size = 32M

# Other
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci

#########
# 4CPUs 16G
#########
# MariaDB Configuration File

# Server
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Logging
log_error=/var/log/mysql/error.log
general_log=0
general_log_file=/var/log/mysql/mysql.log

# MyISAM
key_buffer_size = 256M
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 10G
myisam_repair_threads = 4

# InnoDB
innodb_buffer_pool_size = 8G
innodb_log_file_size = 2G
innodb_log_buffer_size = 256M
innodb_file_per_table = 1
innodb_open_files = 2000
innodb_io_capacity = 500
innodb_io_capacity_max = 1000
innodb_flush_method = O_DIRECT

# Connection
max_connections = 200
max_allowed_packet = 64M
wait_timeout = 28800
interactive_timeout = 28800

# Query Cache (Disabled)
query_cache_type = 0
query_cache_size = 0

# Performance
thread_cache_size = 100
tmp_table_size = 64M
max_heap_table_size = 64M
join_buffer_size = 4M
read_buffer_size = 4M
read_rnd_buffer_size = 2M
sort_buffer_size = 8M

# Other
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci