BIP KB Tag: Engine
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
Table | Use one file per table with MySQL's INNODB storage
Introduction to MySQL INNODB engine table storage
InnoDB is a general-purpose storage engine that balances high reliability and high performance. In MySQL 5.6, InnoDB is the default MySQL storage engine. Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE= clause creates an InnoDB table.
InnoDB includes all the features that were part of the InnoDB Plugin for MySQL 5.1, p...
By BIP, December 8, 2016