Related Documentation Download this Manual
PDF (US Ltr) - 44.6Mb
PDF (A4) - 44.6Mb
PDF (RPM) - 40.3Mb
HTML Download (TGZ) - 10.5Mb
HTML Download (Zip) - 10.5Mb
HTML Download (RPM) - 9.1Mb
Man Pages (TGZ) - 205.4Kb
Man Pages (Zip) - 308.6Kb
Info (Gzip) - 3.9Mb
Info (Zip) - 3.9Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  MySQL Data Dictionary  /  Removal of File-based Metadata Storage

14.2 Removal of File-based Metadata Storage

In previous MySQL releases, dictionary data was partially stored in metadata files. Issues with file-based metadata storage included expensive file scans, susceptibility to file system-related bugs, complex code for handling of replication and crash recovery failure states, and a lack of extensibility that made it difficult to add metadata for new features and relational objects.

The metadata files listed below are removed from MySQL. Unless otherwise noted, data previously stored in metadata files is now stored in data dictionary tables.

  • .frm files: Table metadata files. With the removal of .frm files:

    • The 64KB table definition size limit imposed by the .frm file structure is removed.

    • The INFORMATION_SCHEMA.TABLES VERSION column reports a hardcoded value of 10, which is the last .frm file version used in MySQL 5.7.

  • .par files: Partition definition files. InnoDB stopped using partition definition files in MySQL 5.7 with the introduction of native partitioning support for InnoDB tables.

  • .TRN files: Trigger namespace files.

  • .TRG files: Trigger parameter files.

  • .isl files: InnoDB Symbolic Link files containing the location of file-per-table tablespace files created outside of the data directory.

  • db.opt files: Database configuration files. These files, one per database directory, contained database default character set attributes.

User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.