Checking whether InnoDB engine is enabled in MySQL or Not

You can use following simple query to check whether InnoDB engine is enabled or not in MySQL

show engines;

In result, Next to InnoDB engine, in the Support column you will see “Yes” if InnoDB is enabled. If you see “No” then  this means that InnoDB is not enabled in the MySQL configuration.

Posted in:

Leave a Reply