Knowledgebase

How to check whether InnoDB engine is enabled in MySQL

InnoDB is a MySQL storage engine that supports transactions, row-level locking and foreign keys. Many web applications such as Magento require InnoDB to be enabled in order to run properly.

The easiest way to check whether the InnoDB engine is enabled is to log in to phpMyAdmin, click the SQL tab, type the following command in the box:

show engines;

and click Go to execute the query and see the available storage engines.

Next to InnoDB engine, in the Support row you will see Yes if InnoDB is enabled. If you see No, this means that InnoDB is not enabled in the MySQL configuration.

As part ot the HostKnox Magento hosting services, all HostKnox servers have InnoDB enabled and meet all Magento requirements.

Was this answer helpful?

 Print this Article

Also Read