MindMap Gallery How MySQL works
Study notes on the working principle of MySQL, a picture to help you understand the technical details of MySQL. The content is practical, if you need it, collect it quickly!
Edited at 2024-04-08 14:14:05One Hundred Years of Solitude is the masterpiece of Gabriel Garcia Marquez. Reading this book begins with making sense of the characters' relationships, which are centered on the Buendía family and tells the story of the family's prosperity and decline, internal relationships and political struggles, self-mixing and rebirth over the course of a hundred years.
One Hundred Years of Solitude is the masterpiece of Gabriel Garcia Marquez. Reading this book begins with making sense of the characters' relationships, which are centered on the Buendía family and tells the story of the family's prosperity and decline, internal relationships and political struggles, self-mixing and rebirth over the course of a hundred years.
Project management is the process of applying specialized knowledge, skills, tools, and methods to project activities so that the project can achieve or exceed the set needs and expectations within the constraints of limited resources. This diagram provides a comprehensive overview of the 8 components of the project management process and can be used as a generic template for direct application.
One Hundred Years of Solitude is the masterpiece of Gabriel Garcia Marquez. Reading this book begins with making sense of the characters' relationships, which are centered on the Buendía family and tells the story of the family's prosperity and decline, internal relationships and political struggles, self-mixing and rebirth over the course of a hundred years.
One Hundred Years of Solitude is the masterpiece of Gabriel Garcia Marquez. Reading this book begins with making sense of the characters' relationships, which are centered on the Buendía family and tells the story of the family's prosperity and decline, internal relationships and political struggles, self-mixing and rebirth over the course of a hundred years.
Project management is the process of applying specialized knowledge, skills, tools, and methods to project activities so that the project can achieve or exceed the set needs and expectations within the constraints of limited resources. This diagram provides a comprehensive overview of the 8 components of the project management process and can be used as a generic template for direct application.
MySQL
Database definition
database
A physically manipulated file system or other collection of file types
Example
Composed of background threads and a shared memory area
Contains two processes mysqld and mysqld_safe
relation
one-to-one correspondence
Manipulate database files through database instances
An instance is a dedicated interface provided by the database to the upper layer for operations.
Architecture
connection handling
Query parsing, caching, optimization
storage engine
InnoDB
MyISAM
Storage (InnoDB)
logical space
tablespace
segment
area
The extent size and number of pages it contains will vary depending on the page size
Minimum 1MB
Contain at least 64 pages
page
Default 16KB
innodb_page_size
table storage
.frm
Storage table definition
.ibd
Store data index
record storage
Compact
Arrange the length of variable-length fields in reverse order at the beginning of the line
Redundant
Record the offset of each column at the beginning of the row
Antelope
When storing large objects, the data page records 768 bytes, and the subsequent offset points to the overflow page.
Compressed
Dynamic
Barracuda
Recording large objects only retains 20-byte pointers, and the actual data is in the overflow page
data page
Minimum disk unit
The nodes in B-Tree record page information
structure
File Header/Fil Trailer
Record header information
Page Header/Page Directory
Record page status information
Infimum/Supremum
The minimum and maximum values of the primary key of this page
User Records
actual storage records
Stored in linked list structure
Free Space
free space