Table of Contents Briefly introduce the two engines Start actual measurement Comparing the capacity occupied by data, MyISAM occupies less space. From the comparison of query efficiency, MyISAM is indeed faster. MYISAM table structure Laravel table creation statement Laravel scheduled task-clean logs and keep only the latest 3 million records A brief introduction to the […]
Tag: myisam
mysql database engine-Inodb, MyISAM
mysql database engine-Inodb, MyISAM 1. What is a database engine ? Database Engine refers to the core module or software component responsible for data storage, management and access in the database system. It provides operations such as creating, modifying, querying, and deleting databases, and is responsible for processing functions such as data storage, indexing, transaction […]
MySQL database – storage engine (2) – storage engine features (InnoDB, MyISAM, Memory), storage engine selection
Table of Contents Storage engine features InnoDB introduce Features document logical storage structure MyISAM introduce Features document Memory introduce Features document Differences and features Storage engine selection Storage engine features Above we introduced what a storage engine is and how to specify a storage engine when creating a table. Next, we will introduce the three […]
[Mysql] MySQL architecture, InnoDB, MyISAM storage engine, index structure, classification, syntax, performance analysis
1. MySQL architecture connection layer It mainly completes some similar connection processing, authorization authentication, and related security solutions. On this layer, the concept of thread pool is introduced to provide threads for clients that pass authentication and secure access. SSL-based secure links can also be implemented on this layer. The server also verifies the operating […]
MySQL database—storage engine (MyISAM and InnoDB)
Table of Contents foreword 1. Introduction to the concept of storage engine 2. MyISAM 3. InnoDB Fourth, configure the appropriate storage engine Summarize Foreword The database storage engine is the underlying software organization of the database, and the database management system (DBMS) uses the data engine to create, query, update and delete data. Different storage […]
What storage engines does MySQL support? Which one is used by default? What is the difference between MyISAM and InnoDB engines, and how to choose?
m the y S Q L ? Which storage engines are supported? Which one is used by default? m the y I S A m and I no no o D. B What is the difference between the engines and how to choose? \color{#FF1493}{What storage engines does MySQL support? Which one is used by default? […]
The difference between InnoDB and MyISAM storage engines
Directory 1. What is InnoDB 2. What is MyISAM 3. The difference between InnoDB and MyISAM storage engines 1. What is InnoDB InnoDB is a MySQL database engine, which is currently the most commonly used engine in MySQL. InnoDB supports features such as transactions, row-level locking, and foreign key constraints, and can handle data security […]
Briefly describe the InnoDB and MyISAM engines in the database
Directory 1. Modify the default storage engine 2. About the InnoDB engine Advantages of InnoDB Transactional storage engine with foreign key support B+ tree structure of InnoDB index: 3. About the MyISAM engine Advantages of MyISQM Data Structures for MyISAM Indexes 4. Comparison between InnoDB and MyISAM engines 1. Modify the default storage engine Prerequisite: […]
MySQL-storage engine: architecture (connection layer, service layer, engine layer, storage layer), storage engine introduction, storage engine features: InnoDB (features, logical storage structure), MyISAM, Memory, differences and characteristics, storage engine selection
Release Note Current version number [20230410]. Version Modification Description 20230410 First edition Knowledge Summary Table of Contents Article directory Release Notes knowledge overview Table of contents storage engine 1.1 MySQL architecture 1). Connection layer 2). Service layer 3). Engine layer 4). Storage layer 1.2 Storage Engine Introduction 1). Specify the storage engine when creating the […]