How to check if MYSQL supports InnoDB or not?

by
Tweet
Share2
Pin
2 Shares

Following SQL Queries are helpful in determining the InnoDB status of MYSQL:

1>

SHOW VARIABLES LIKE '%have_innodb%';

Result:
SHOW VARIABLES LIKE '%have_innodb%';

2>

SHOW ENGINES;

Result:
SHOW ENGINES;

You can use these queries in case of Magento too in order to determine the InnoDB status.

Cheers!!

Tweet
Share2
Pin
2 Shares

Related posts:

  1. Custom Login Redirect Pro: How to keep your customer logged in even after redirection to another store?
  2. Bash Script: Create MySQL Database & User with Optional Password
  3. How to check if the customer is already logged in from another location?
  4. MySQL Issue: Table storage engine for ‘catalog_product_relation’ doesn’t have this option