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

pico /etc/mysql/my.cnf

Add the following line


Restart MySQL

/etc/init.d/mysql restart

About Rick

Senior Front-end Software Engineer from Barcelona, Haidong Gumdo Instructor (korean martial art of the sword), street photographer, travel lover, TV addict, Boston Red Sox fan, and privacy advocate.

Leave a Reply

Add <code> Some Code </code> by using this tags.