mysql ".frm" refers to the table definition, a file describing the table structure, and ".ibd" refers to the file of table data and indexes. Each non-leaf of the table's index (B-tree) The node stores the index, and the leaf nodes store the index and the data corresponding to the index.
The operating environment of this tutorial: Windows 10 system, MySQL version 5.7, Dell G3 computer.
What is the file mysql.frm?
mysql database
The storage engine is myisam. You will see 3 types of files in the data directory:. frm, .myi, .myd
(1) *.frm--Table definition, which is a file describing the table structure.
(2)*.MYD--"D" data information file, which is the data file of the table.
(3)*.MYI--"I" index information file, which is the data tree of any index in the table data file
The storage engine is InnoDB, in data You will see 2 types of files in the directory: .frm, .ibd
(1) *.frm--table structure file.
(2)*.ibd--files for table data and indexes. Each non-leaf node of the index (B tree) of the table stores the index, and the leaf nodes store the index and the data corresponding to the index.
Related introduction:
MySQL is a relational database management system developed by the Swedish MySQL AB company and is a product of Oracle. MySQL is one of the most popular relational database management systems. In terms of WEB applications, MySQL is one of the best RDBMS (Relational Database Management System) application software.
MySQL is a relational database management system. A relational database stores data in different tables instead of placing all data in one large warehouse, which increases speed and flexibility.
The SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software adopts a dual licensing policy and is divided into community version and commercial version. Due to its small size, fast speed, low total cost of ownership, and especially the characteristics of open source, MySQL is generally chosen as the website for the development of small, medium and large websites. database.
[Related recommendations: mysql video tutorial]
The above is the detailed content of What file is mysql.frm?. For more information, please follow other related articles on the PHP Chinese website!