By default, the MyISAM table will generate three files on the disk: .frm (table structure file), .MYD (data file), and .MYI (index file) You can specify the storage location of data files and index files when creating them. Only MyISAM tables support this:
The maximum amount of data supported by a single MyISAM table is 2 to the 64th power of jump records A maximum of 64 indexes can be created for each table. If it is a composite index, each composite index contains a maximum of 16 columns, and the maximum length of the index value is 1000B The storage format of the MyISAM engine is:
InnoDB storage engine: The design follows the ACID model, supports transactions, has the ability to recover from service crashes, and can protect user data to the greatest extent possible. Support row-level locks, which can improve the read and write performance of multiple users concurrently InnoDB has its own independent buffer pool, and commonly used data and indexes are cached. For INSERT, UPDATE, and DELETE operations, InnoDB uses a change buffering mechanism to automatically optimize, provide consistent reads, and cache changed data to reduce disk I/O and improve performance. After creating an InnoDB table, two files will be generated:
All tables need to create a primary key, preferably with AUTO_INCREMENT, or put it in a frequently queried column as the primary key The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM. You may also be interested in:
|
>>: Super detailed basic JavaScript syntax rules
——Notes from "MySQL in Simple Terms (Second ...
Under the requirements of today's responsive ...
Table of contents 1. What is lazy loading of rout...
For commercial databases, database upgrade is a h...
CSS3 implements a flippable hover effect. The spe...
Preface The essence of deadlock is resource compe...
This article shares the specific code of js to im...
MySQL DATE_ADD(date,INTERVAL expr type) and ADDDA...
1. Configure local yum source 1. Mount the ISO im...
Table of contents Problem description: Solution 1...
WML (Wireless Markup Language). It is a markup la...
Table of contents 1. Front-end leading process: 2...
Go is an open source programming language that ma...
Database Command Specification All database objec...
Table of contents 1. Preparation before installat...