How to test if innoDb engine enabled in MySQL

[Scott Jacobs]

To check whether innoDb engine is enabled or not follow the below commands:

1. Login to shell to fire the command – mysql

After firing the above command you see:

================================================== ==
[[email protected] ~]# mysql
Welcome to the MySQL monitor. Commands end with; or \g.
Your MySQL connection id is xxxx
Server version: x.x.xx-community MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
================================================== ==

After this fire the below command:

mysql> SHOW VARIABLES LIKE 'have_innodb';

The output will be like the following:

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_innodb | YES |
+---------------+-------+
1 row in set (0.00 sec)

If it is "yes" then the server has innoDb engine enabled, and if "No" then vise-versa.

Now exit by executing the quit command.