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 

CrownCloud - Get a SSD powered KVM VPS at $4.5/month!
Use the code WELCOME for 10% off!

1 GB RAM / 25 GB SSD / 1 CPU Core / 1 TB Bandwidth per month

Available Locations: LAX | MIA | ATL | FRA | AMS