Show tables by engine in MySQL

mysql storage-engines
Kit Peters picture Kit Peters · Nov 11, 2009 · Viewed 68.2k times · Source

How would I show all tables in MySQL with a given engine, e.g. InnoDB, MyISAM, FEDERATED?

Answer

ChssPly76 picture ChssPly76 · Nov 11, 2009

Use INFORMATION_SCHEMA.TABLES table:

SELECT table_name FROM INFORMATION_SCHEMA.TABLES
  WHERE engine = 'InnoDB'

Related questions

Create mysql table directly from CSV file using the CSV Storage engine?

I just learned that MySQL has a native CSV storage engine which stores data in a Comma-Separated-Value file per table. Is it possible to create a table directly from a uploaded CSV file, something like: CREATE TABLE USERS < PATH/…

Read More
How do I know if a mysql table is using myISAM or InnoDB Engine?

In MySQL, there is no way to specify a storage engine for a certain database, only for single tables. However, you can specify a storage engine to be used during one session with: SET storage_engine=InnoDB; So you don't …

Read More
See what storage engine MySQL database uses via terminal

Is there a command in terminal for finding out what storage engine my MySQL database is using?

Read More