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

Serie(s): Administering MySQL from the command line, 10 (14)

The tutorials here on LibreByte are provided under a free software licence. if you like my work you should consider:
Buy a Hosting/VPS or Dedicated Server at MCKHost

Leave a Reply

Your email address will not be published.

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