Disabling InnoDB in MySQL

Disabling InnoDB in MySQL helps you save a lot of RAM especially if you don't need it.

If your script/software needs InnoDB, disabling InnoDB will cause issues!

First, open the MySQL config file,

nano /etc/my.cnf 

Find the section [mysqld] and add skip-innodb below it. So it looks like this,

[mysqld] 
skip-innodb 

Save the file and restart MySQL,

service mysqld restart 

and then check your RAM usage to see if it has reduced, with the following command,

free -m 

Last modified: March 14 2017 15:38:03