Announcement

Collapse
No announcement yet.

How to check innoDb engine is enabled or not in MySQL

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to check innoDb engine is enabled or not in MySQL

    Hi,
    How do I check whether innoDb engine is enabled in MySQL?
    Any help will be really appreciated.

  • #2
    Hello,

    1. Sign in to shell to fire the command mysql

    After firing the above command you will see:
    ************************************************** **
    [root@vps ~]# 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 following command:

    mysql> SHOW VARIABLES LIKE 'have_innodb';
    The output will be like the below:

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

    Comment

    Working...
    X