Sample analysis of MySQL table files

Introduction to MySQL table files

One database corresponds to one folder

One table corresponds to one or more files

Engine myisam, one table corresponds to three files

.frm stores the table structure

.myd stores the table data

.myi stores the index of the table data

Engine innodb, one table corresponds to a table structure file, all table data of innodb are saved together in the ibdata1 file. When the database scale increases, files such as ibdata2 and ibdata3 will be automatically created

.myd stores table data

Note: It is recommended to use the innodb engine

The difference between innodb engine and myisam engine:

The above is the detailed content of Sample analysis of MySQL table files. For more information, please follow other related articles on the PHP Chinese website!