How to view the storage engine type of tables in mysql

Source: Internet
Author: User
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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.