Save your config to /etc/mysql/mariadb.conf.d/90-custom-server.cnf
. Optimal values for the fine tuning and limits sections depends on your workload and environment, so make sure to tune them yourself.
[mysqld]
# Fine tuning
innodb_buffer_pool_size = xxxxM
innodb_log_file_size = xxM
max_connections = 500
transaction_isolation = READ-COMMITTED
# Limits
max_allowed_packet = 32M
# Security
sql_mode = STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
local_infile = 0
This is just a starting point, and you may encounter more issues as you scale up, for example the default innodb_io_capacity
, innodb_read_io_threads
and innodb_write_io_threads
could become a bottleneck and prevent you from fully utilizing your SSD RAID.