MySQL: How To Show All Tables Running INNODB Engine

mysql server This short tutorial will show you how to show all database tables running INNODB engine on a mysql server.

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)

In my next MySQL post I'll look at how the INNODB storage engine by default puts all the tables into a single file called ibdata1 and how you can change the default to have a single file per table in the same way that the MyISAM storage engine does. For more information on Server Commands or any other topics of interest search the CLC Community Learning Center.

Tags: Linux, mysql, Engine, INNODB, INNODB Engine, SolarSystem Video Tutorials, Tables, Windows

---

Welcome to the healthcare-only HIPAA - GDPR compliant cloud. Exclusively hosted on a HPC environment!

Learn more or start today by choosing your secure HIPAA - GDPR compliant server's Operating System bellow and pick the package that's best for you.

Leave a Reply