Optimize MySQL turning Off InnoDB

If your MySQL databases uses MyISAM instead of InnoDB you should turn the last one Off.

It should free memory and optimize your MySQL performance.

I just did it on my VPS after that the mysql process (using top command) uses less memory.

Edit my.cnf

nano /etc/mysql/my.cnf

Add the following line

skip-innodb

Restart MySQL

/etc/init.d/mysql restart

Leave a Reply

Your email address will not be published. Required fields are marked *