After mysql created the table, the table structure file could not be found, but it could be used normally.

mac installed on the mysql8.0 version, the new database (innodb) and a test table, in the data file directory there should be a corresponding database file, there should be a table structure file called xxx.frm, but I this directory there is only a xxx.ibd file, the book says that frm file is a table structure file every table must have one, and I query insert is normal. What"s going on?

Jun.06,2021

first of all, I would like to give you a like. I really didn't notice this new feature after the release of 8.0. I just went to mysql's official website to check it, as follows:

The .frm metadata files previously associated with base tables and views no longer exist. Metadata previously stored in .frm files is now stored in data dictionary tables.

Similarly, trigger metadata previously stored in .TRG and .TRN files is stored in adata dictionary table and those files no longer exist.

probably means that the .frm metadata file no longer exists and is now stored in the data dictionary table. As for where the data dictionary is, I didn't take a closer look at it, it should be in the information_schema library, and there is still a lot of change compared to the following table. The
also gives a message. The TRG trigger file no longer exists.
Portal

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b326fc-2be40.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b326fc-2be40.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?