CrownCloud Wiki

CrownCloud - Internet Services

User Tools

Site Tools


disabling_innodb

Disabling InnoDB in MySQL

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

Do note, if your existing script/software installed on your VPS needs InnoDB enabled, check this before disabling InnoDB or else your script/software which needs it will stop working

Firstly, 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 
disabling_innodb.txt · Last modified: 2013/07/24 10:40 by speedbus