We recently saw that .frm files have been somewhat of replaced for MyISAM tables in MySQL 8.0 (see this post).
However, what are those files ? Can they be used for something else than MyISAM tables ? … Let’s try to answer those questions and get more familiar with the .sdi files.
What does SDI stand for ?
SDI acronym stands for Serialized Dictionary Information.
As you may know already, MySQL 8.0 replaced the old way to store the metadata of tables, their structure, into the new transactional Data Dictionary (in InnoDB).
Additionally, that information is also part any InnoDB tabespace , its is appended to the tablespace, so the meta data and data are bundled …
[Read more]