Show MySQL storage engines

This entry is part 6 of 9 in the series: Administering MySQL from the command line

To see the available/enabled MySQL storage engines first you must connect to your mysql server

$ mysql - u root - p - h SERVER

Then run

mysql>show engines;
+------------+----------+---------------------------------
| Engine     | Support  | Comment                         
+------------+----------+---------------------------------
| MyISAM     | DEFAULT  | Default engine as of MySQL 3.23 
| MEMORY     | YES      | Hash based, stored in memory, us
| InnoDB     | YES      | Supports transactions, row-level
| BerkeleyDB | DISABLED | Supports transactions and page-l

To see storage engines for certain tables, run the following statement

mysql> SELECT TABLE_NAME, ENGINE
FROM   INFORMATION_SCHEMA.TABLES
WHERE  TABLE_NAME IN ('TABLA1', 'TABLA2', 'TABLA13');

If you want to view for all tables of a database then run

mysql> SELECT TABLE_NAME, ENGINE
FROM   INFORMATION_SCHEMA.TABLES
WHERE INFORMATION_SCHEMA.TABLES.TABLE_SCHEMA='BASE_DATO';

Recommended reading

-F. van der lan, Rick. SQL for MySQL Developers, Part III, Chapter 20