BIP KB Tag: Tables

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 | +--------------+-----------------------+---...
By daniel, March 18, 2015