2016년 5월 12일 목요일

How to Disable InnoDB On MySQL and MariaDB

How to Disable InnoDB On MySQL and MariaDB


CentOS 7.x

# vi /etc/my.cnf

[mysqld]
skip-innodb
default-storage-engine=MyISAM

# systemctl restart mariadb.service


Disabling innoDB on older versions

# vi /etc/my.cnf

[mysqld]
skip-innodb

# service mysql restart