MariaDB performance tuning

my.cnf

[mysqld]
innodb_buffer_pool_size=1G # Default: 128M. Ideally, this is 80% of the available RAM
max_connections=301 # Default: 151. Increase for more concurrent connections if you have the resources.
query_cache_size=64M # Default: 0

# Check configuration of custom variables above
show variables like 'innodb_buffer%';
show variables like '%connections%';
show variables like '%query_cache%';

# Display query cache utilization
show status like 'Qcache%';