MySQL: How To Show All Tables Running INNODB Engine

This short tutorial will show you how to show all database tables running INNODB engine.

  1. Login into MySQL

mysql> use mysql; 
mysql> SELECT table_schema, table_name, engine FROM INFORMATION_SCHEMA.TABLES WHERE engine = 'innodb';

Results:

+--------------+-----------------------+--------+
| table_schema | table_name            | engine |
+--------------+-----------------------+--------+
| pdns         | domains               | InnoDB |
| pdns         | records               | InnoDB |
| pdns         | supermasters          | InnoDB |
| pdns         | zone_templ            | InnoDB |
| pdns         | zone_templ_records    | InnoDB |
| pdns         | zones                 | InnoDB |
| vmails       | vacation              | InnoDB |
| vmails       | vacation_notification | InnoDB |
+--------------+-----------------------+--------+
8 rows in set (0.00 sec) 

Ralph Gervolino

Leave a Reply