InnoDB engine enabled or not cPanel

Stop worrying about your server.

cPanel Server Management for just $59/mo with Unlimited tickets, Unlimited admin hours, Security audits, 24×7 monitoring and lot more 

cPanel Server Management  $59/mo Click here

InnoDB engine enabled or not cPanel:

You can check whether the innoDB engine is enabled or not in your linux server by the following method,

First you need to login to the mysql server from the command line using the following command,

mysql

[email protected] [~]# mysql

Now you will enter into the mysql prompt and you will get a welcome message as below,

[[email protected] [~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 257012
Server version: 5.1.69 Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

Now enter the following query on the mysql prompt,

SHOW VARIABLES LIKE 'have_innodb';

Now you will get result as follows,

mysql> SHOW VARIABLES LIKE 'have_innodb';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_innodb | YES |
+---------------+-------+
1 row in set (0.00 sec)

You can now simply make sense from the result that innodb is enabled or not.

Need our help to fix the issue ? Submit Support Ticket Now

View Server Administration Packages

Leave a Reply

Your email address will not be published. Required fields are marked *