Discussion: What are the features and differences between innodb and myisam on storage _ MySQL

Discussion: What are the features and differences between innodb and myisam on storage? bitsCN.com

Myisam stores data in three files: MYD,. MYI,. FRM, and index files.
Innodb stores data including. FRM storage table definition ,. ibd (exclusive tablespace ),. ibdata (shared tablespace ). innodb stores data in standalone and shared tablespaces (which is determined by the innodb_file_per_table variable). ibd "file to store data, and each table has a". ibd file, which is stored in the same location as MyISAM data, determined by datadir. If you use a shared storage tablespace to store data, ibdata files are used for storage. one or more ibdata files can be used for all tables. The ibdata file can be passed through innodb_data_home_dir and innodb_data_file_path
The two parameters are configured together. innodb_data_home_dir configures the directory where data is stored.

Note:
Although we can use the shared tablespace or exclusive tablespace to store our tables, the shared tablespace must exist, because Innodb's undo information and other metadata information are stored in the shared tablespace.

BitsCN.com