Which MySQL engine am I using?

20 Sep 2012

How to find out which MySQL engine you're using for a particular database or table? Run this query:

SELECT table_schema, table_name, engine FROM INFORMATION_SCHEMA.TABLES;

Thanks to Electric Toolbox for the answer.

Name (required)
Email (required)
Website
The site is named after Saint ________ the Carpeted: (required)
Comment

Carousel is a LIE!