How To check if innodb enabled or not

How to check if innodb is enabled or not?

[[email protected] ~]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 343316 to server version: 4.1.22-standard
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql> SHOW VARIABLES LIKE ‘have_innodb’;
+—————+——-+
| Variable_name | Value |
+—————+——-+
| have_innodb   | YES   |
+—————+——-+
1 row in set (0.00 sec)
mysql>
It will show provided output.

Tagged . Bookmark the permalink.

Leave a Reply