MySQL MyISAM engine does not support transactions

Find the spring transaction rollback error for one day and finally find the MySQL MyISAM engine.

It does not support transaction processing ~~~ Let's take a look at mysql.

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

The two most commonly used storage engines:

1. Myisam is the default storage engine of Mysql. When create creates a new table without specifying the storage engine for the new table, Myisam is used by default. Each MyISAM is stored as three files on the disk. The file names are the same as the table names. The extensions are. frm (storage table definition),. MYD (MYData, storage data), and. MYI (MYIndex, storage index ). Data Files and index files can be placed in different directories, and I/O is evenly distributed for faster speed.

2. the InnoDB Storage engine provides transaction security with commit, rollback, and crash recovery capabilities. However, compared with the storage engine of Myisam, InnoDB is less efficient in writing and occupies more disk space to retain data and cable.