What does mysql engine mean?

mysql engine represents the storage engine. The storage engine is a specific subsystem in MySQL that deals with files. The MySQL storage engine is plug-in. It is based on an abstract interface of the file access layer provided by MySQL AB. Customize a file access mechanism.

Engine: Storage engine

The storage engine is the specific subsystem in MySQL that deals with files. . It is also the most distinctive feature of MySQL.

MySQL's storage engine is plug-in. It customizes a file access mechanism based on an abstract interface of the file access layer provided by MySQL AB (this access mechanism is called a storage engine).

There are many kinds of storage engines now, and each storage engine has different advantages. The most commonly used ones are MyISAM, InnoDB, and BDB.

By default, MySQL uses the MyISAM engine, which has fast query speed and good index optimization and data compression technology. But it does not support transactions.

InnoDB supports transactions and provides row-level locking, which is also widely used.

MySQL also supports customizing its own storage engine. Even different tables in a database use different storage engines. These are all allowed.

Recommended: "mysql tutorial"

The above is the detailed content of What does mysql engine mean?. For more information, please follow other related articles on the PHP Chinese website!