MySQL/MariaDB config

config database

MySQL/MariaDB server custom configuration

/etc/mysql/conf.d/custom.cnf

Required Packages

sudo apt install -y mariadb-server

Server Settings [mysqld]

Bind address

0.0.0.0 for all interfaces, 127.0.0.1 for local only

Port

Max connections

Default: 151

InnoDB buffer pool size

Recommended: 50-70% of available RAM for dedicated DB server

Character set

Collation

Max allowed packet

Maximum size of a single packet (e.g. 64M)

InnoDB log file size

Larger values improve write performance

Error log path

Enable slow query log Enable slow query log

Generated Config — /etc/mysql/conf.d/custom.cnf

[mysqld] bind-address = 127.0.0.1 port = 3306 max_connections = 151 innodb_buffer_pool_size = 128M character-set-server = utf8mb4 collation-server = utf8mb4_general_ci

systemctl mysql_secure_installation LAMP stack setup LEMP stack setup

MySQL/MariaDB config

Server Settings [mysqld]

Generated Config — /etc/mysql/conf.d/custom.cnf

Related