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
Let's look at the code first: ALTER TABLE rep...
Table of contents Complex query and step-by-step ...
http://www.cppcns.com/shujuku/mysql/283231.html Y...
Preface When using the Deepin user interface, it ...
conda update conda pip install tf-nightly-gpu-2.0...
Table of contents vue router 1. Understand the co...
WML (Wireless Markup Language). It is a markup la...
1. W3C versions of flex 2009 version Flag: displa...
1. What is Docker Secret 1. Scenario display We k...
Table of contents 1. Project environment: 2: DNS ...
Table of contents 1. Demand 2. Effect 3. All code...
In an article a long time ago, I talked about the...
Join uses the Nested-Loop Join algorithm. There a...
Directory Structure . │ .env │ docker-compose.yml...
The layui table has multiple rows of data. Throug...