So I am in the process of migrating from a CentOS 5 VPS to a CentOS 7 one. I run various services on my VPS, most of the services are light on resources. I am running MariaDB for this blog, and only for this blog. I am not using MyISAM tables, meaning I can disable InnoDB. This will free up some RAM on the box.
- Modify ‘/etc/my.cnf’ by adding the following lines:
[mysqld] skip-innodb default-storage-engine=MyISAM datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 # Settings user and group are ignored when systemd is used. # If you need to run mysqld under a different user or group, # customize your systemd unit file for mariadb according to the # instructions in http://fedoraproject.org/wiki/Systemd [mysqld_safe] log-error=/var/log/mariadb/mariadb.log pid-file=/var/run/mariadb/mariadb.pid # # include all files from the config directory # !includedir /etc/my.cnf.d
- The restarted MariaDB
systemctl restart mariadb