How to view the storage engine type of tables in mysql

Mysql supports multiple storage engines. When processing different types of applications, you can use different storage engines to improve application efficiency or provide flexible storage. Mysql storage engines include: MyISAM, InnoDB,

Mysql supports multiple storage engines. When processing different types of applications, you can use different storage engines to improve application efficiency or provide flexible storage. Mysql storage engines include: MyISAM, InnoDB,

Mysql supports multiple storage engines. When processing different types of applications, you can use different storage engines to improve application efficiency or provide flexible storage.

Mysql storage engines include MyISAM, InnoDB, BDB, MEMORY, MERGE, EXAMPLE, NDB Cluster, ARCHIVE, CSV, BLACKHOLE, and FEDERATED. InnoDB and BDB provide transaction security tables, other storage engines are non-transaction security tables.

There are several methods to view the table storage engine type in mysql:

1. show table status from database name where, for example:

Mysql> show engines;

+ ------------ + --------- + ---------------------------------------------------------- + (Partial results are omitted)

| Engine | Support | Comment | (partial results are omitted)

+ ------------ + --------- + ---------------------------------------------------------- + (Partial results are omitted)

| InnoDB | NO | Supports transactions, row-level locking, and foreign keys | (partial results are omitted)

| MRG_MYISAM | YES | Collection of identical MyISAM tables | (partial results are omitted)

| BLACKHOLE | YES |/dev/null storage engine (anything you write to it disa (partial results are omitted)

| CSV | YES | CSV storage engine | (partial results are omitted)

| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | (partial results are omitted)

| FEDERATED | NO | Federated MySQL storage engine | (partial results are omitted)

| ARCHIVE | YES | Archive storage engine | (partial results are omitted)

| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | (partial results are omitted)

+ ------------ + --------- + ---------------------------------------------------------- + (Partial results are omitted)

8 rows in set (0.00 sec)

Mysql>

This article is from the "" blog. Please keep this source