No announcement yet.

How to test if innoDb engine enabled in MySQL

  • Filter
  • Time
  • Show
Clear All
new posts

  • How to test if innoDb engine enabled in MySQL

    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.
    ================================================== ==
    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.