Wednesday, May 30, 2012

How to turn off Innodb in mysql?


How to turn off Innodb in mysql?
March 5th, 2011Amit Honrao1 comment

Innodb is by default installed with mysql, You can verify whether Innodb is set to On or Off by using following command.

mysqladmin variables

mysqladmin variables | grep have_innodb

If you want to disable it so you can do it using following steps.

Edit mysql configuration file

vi /etc/my.cnf

add this in my.cnf file

skip-innodb

Save and exit from file using Esc !wq the enter

No comments:

Post a Comment