In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-04 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
MyISAM
The default database engine before Mysql5.5 is the most commonly used. Has high insert and query speed, but does not support transactions
InnoDB
The preferred engine for transactional database, which supports ACID transactions and row-level locking. MySQL 5.5 has become the default database engine since.
BDB is derived from Berkeley DB, an alternative to transactional databases that supports other transaction features such as COMMIT and ROLLBACK
Memory
All data is stored in memory in the storage engine, with high insertion, update and query efficiency. But it takes up memory space proportional to the amount of data. And its contents will be lost when Mysql is restarted
Merge
Combine a certain number of MyISAM tables into a whole, which is useful for very large-scale data storage.
Archive
It is very suitable for storing large amounts of independent data as historical records. Because they are not often read. Archive has efficient insertion speed, but its support for queries is relatively poor.
Federated
Combine different Mysql servers to logically form a complete database. Very suitable for distributed applications
Cluster/NDB
A highly redundant storage engine that uses multiple data machines to jointly provide services to improve overall performance and security. Suitable for applications with large amount of data, high security and performance requirements
CSV
A storage engine that logically splits data by commas. It creates a .CSV file for each data table in the database subdirectory. This is a normal text file that takes up one line of text per line of data. The CSV storage engine does not support indexing.
BlackHole
Black hole engine, any data written will disappear. It is generally used to record the relay of binlog replication.
EXAMPLE
The storage engine is a stub engine that does nothing. It is intended as an example in the MySQL source code to demonstrate how to start writing a new storage engine. Again, its main interest is for developers. Indexing is not supported by the EXAMPLE storage engine.
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.