Home  >  Article  >  Database  >  What does mysql engine mean?

What does mysql engine mean?

藏色散人
藏色散人Original
2020-07-01 09:18:224110browse

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.

What does mysql engine mean?

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:what is mysql optimizerNext article:what is mysql optimizer