Source: Various storage engines in MySQL databaseMySQL has a variety of storage engines, each storage engine has its own advantages and disadvantages, you can choose the preferred use :
MyISAM, InnoDB, MERGE, MEMORY (HEAP), BDB (BerkeleyDB),
What is the storage engine?
Data in MySQL is stored in files (or memory) using different technologies. Each of these technologies uses different storage mechanisms, indexing techniques, locking levels, and ultimately provides a wide range of
MySQL's common storage engines are MyISAM, InnoDB, MEMORY, and MERGE. InnoDB provides transaction security tables, and other storage engines are non-transaction security tables. MyISAM is the default storage engine of MySQL. MyISAM does not support
The four storage engines commonly used in MySQL are: MyISAM storage engine, InnoDB storage engine, memory storage engine, archive storage engine. This article focuses on these four storage engines, and finally compares the four storage
This article mainly introducesMySQLDatabaseStorage EngineMySQL has multiple storage engines: MyISAM, InnoDB, MERGE, MEMORY (HEAP), BDB (BerkeleyDB), EXAMPLE, FEDERATED, ARCHIVE, CSV, and BLACKHOLE.
MySQL supports several storage engines as
The strength of MySQL is its plug-in storage engine, which allows us to use different storage engines based on table features to achieve the best performance.MySQL has a variety of storage engines: MyISAM, InnoDB, MERGE, Memory (HEAP), BDB
I. MySQL storage engine classification and applicationMyISAM, InnoDB, MERGE, MEMORY (HEAP), BDB (BerkeleyDB), EXAMPLE, Federated, ARCHIVE, CSV, Blackhole.MySQL supports several storage engines as a processor for different types of tables. The MySQL
ObjectiveThe database storage engine is the database's underlying software organization, and the Database management system (DBMS) uses the data engine to create, query, update, and delete data. Different storage engines provide different storage
The MySQL storage engine InnoDB, MyISAM, and other storage engines introduce the constant updates and changes of MySQL. In fact, the most important thing is the change and upgrade of the storage engine, which also derive many different storage
In the database is a sheet of inextricably linked tables, so the table design is good or bad, will directly affect the entire database. While designing the table, we will focus on one issue and what storage engine to use. Wait a minute, storage
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.