How to check if MYSQL supports InnoDB or not? June 23, 2019October 15, 2011 by Raj KB Following SQL Queries are helpful in determining the InnoDB status of MYSQL: 1> SHOW VARIABLES LIKE '%have_innodb%'; Result: 2> SHOW ENGINES; Result: You can use these queries in case of Magento too in order to determine the InnoDB status. Cheers!!