Detailed description of MySQL Data Table types

There are many types of MySQL Data Tables. The following describes these types of MySQL Data Tables in detail. If you are interested in the types of MySQL Data Tables, take a look.

MySQL supports five different table types: BDB, HEAP, ISAM, MERGE, and MyISAM. Among them, the BDB type is a separate class, called "transaction security" transaction-safe), and the other table types belong to the second class, called "non-transaction Security" non-transaction-safe ).

1. ISAM data table
MySQL versions earlier than MySQL 3.23 have a unique table type. Currently, the MyIASM processing process Library gradually replaces the ISAM processing program. This old table type is no longer in use.

Storage of data tables on hard disks: IASM Frm isd ism

2. MyIASM data table
This is the default data table type used by MySQL. Its advantages are:
If the host operating system supports large-sized files, the data table length can be very large and more data can be accessed.
The data table content is independent of the hardware, that is, the data table can be copied between machines at will.
Improved indexing functions
Provides better index key compression performance
Auto_incremnet enhanced capabilities
Improved the data table integrity check mechanism
Supports full fulltext search

How to store data tables on a hard disk: MyISAM Frm myd myi

3. Merge data table
This is a way to organize a MyIASM data table with the same structure into a logical unit.

Storage of data tables on hard disks: Merge Frm mrg

4. HEAP data table
This is a data table that uses memory, and the length of each data row is fixed. These two features make it very fast to search for such data tables. As a temporary data table, HEAP is useful in certain situations.

Storage of data tables on hard disks: Heap Frm

5. BDB data table
This type of data table supports transaction processing and has good concurrency performance.

Storage of data tables on hard disks: BDB Frm db

6. InnoDB data table
This is the data table Type recently added to MySQL and has many new features.
Support Transaction Processing Mechanism
Immediate recovery after crash
Supports Foreign keys, including cascading deletion.
Concurrency

Storage of data tables on hard disks: InnoDB frm

Set of MySQL Fields

Add and delete fields in MySQL

MySQL Field Type

Mysql foreign Key Usage Analysis

Seven considerations for converting MySQL to Oracle