How to change the storage engine to InnoDB
1.Edit the /etc/my.cnf file and look for this line:
skip-innodb
and comment it out:
#skip-innodb
2.Add the following entry in the /etc/my.cnf file
default-storage_engine = InnoDB
3. Save the file, and restart mysql
/etc/rc.d/init.d/mysqld restart
4. You can use the following command to check the “storage engine” used in the server.
mysqladmin variables | grep storage_engine
You will see the storage engine as “InnoDB”.
# mysqladmin variables | grep storage_engine
| storage_engine | InnoDB
| storage_engine | InnoDB
Leave a Reply
You must be logged in to post a comment.
