Disable innodb engine in MySQL


To disable a storage engine in mysql we must:

Edit the my.cnf file

# vim /etc/my.cnf

Add to the file


For example, to disable innodb add to the file


Restart the mysql server

CentOS / Fedora / RHEL

# service mysqld restart

Debian, Ubuntu and other distros

# /etc/init.d/mysqld restart

Information about the engines

# mysql - u root - p - e 'show engines;'

The above command would be:

MySQL engines

Administering MySQL from the command line, 11 (15)

Leave a Comment

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.