Detect whether MySQL is using InnoDB engine

Run the following query to detect whether yoru mysql db is a InnoDB or not.

SELECT 
    engine
FROM
    information_schema.tables
WHERE
    table_schema = 'YourSchemaName'
        AND table_name = 'AnyTableName';

Output:

+--------+
| ENGINE |
+--------+
| InnoDB |
+--------+