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,


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