MariaDB is a fork of the MySQL database management system. It was created as a community-driven alternative to MySQL, after concerns arose over its acquisition by Oracle Corporation.
MySQL Configuration Settings
MySQL Configuration settings are located at: /etc/mysql/my.cnf
If MariaDB is installed, the my.cnf file likely references: /etc/mysql/mariadb.conf.d/50-server.cnf
MySQL Memory Configuration
To increase the amount of memory available to MySQL on Linux, you can use the –innodb_buffer_pool_size option in the MySQL configuration file (e.g. /etc/my.cnf or /etc/mysql/mariadb.conf.d/50-server.cnf) and then restart the MySQL server to apply the change.
MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability.
To install: sudo apt-get install mysqltuner
To run: sudo mysqltuner