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

About Ricard Torres

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

@ricard_dev @ricard_dev

📝 Blog 🎙 Podcast

Leave a Reply

Add <code> Some Code </code> if you need to.

*
*