mariadb/performance_tuning.cnf


1
2
3
4
5
6
7
8
9
10
11

[mysqld]
innodb_buffer_pool_size = 8G
innodb_log_buffer_size = 512M
innodb_log_file_size = 128M
innodb_write_io_threads = 16
innodb_flush_log_at_trx_commit = 2

# SSD tweaks
innodb_checksum_algorithm = crc32
innodb_flush_neighbors = 0
innodb_io_capacity = 1000