BIP KB:
MySQL: How To Show All Tables Running INNODB Engine

Article By daniel Dhar


img

mysql innodb myisam 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: , , , , , , ,

Spin up a VPS server in no time flat

Simple setup. Full root access. Straightforward pricing.

DEPLOY VPS SERVER

Leave a Reply



Feedbacks