How to check if MYSQL supports innodb or not?

October 15, 2011  |  No Comments  |  by Raj (MagePsycho)  |  Magento, Mysql

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!!

Posted in Magento, Mysql. Bookmark the permalink.

About Raj (MagePsycho)

Raj, the guy behind MagePsycho is a Zend PHP5 Certified Engineer, Magento Certified Developer, Magento Moderator / Freelancer with specialization in web applications (CMS, E-Commerce, ERP etc.). Catch him on: Twitter: @magepsycho Skype: magentopycho