You made some table definition changes to a schema in your MySQL Server. Which two statements reflect how MySQL Server handles the table definition changes? (Choose two.)
A.
MySQL writes SDI to the binary log for distributed backups.
B.
MySQL keeps InnoDB metadata changes in .sdi files in datadir.
C.
The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).
D.
MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.
E.
MySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.
C. The metadata is serialized in JSON format in Serialized Dictionary Information (SDI): When you make changes to the table schema (e.g., adding or modifying columns), MySQL serializes the metadata changes into a JSON format known as Serialized Dictionary Information (SDI). This information is stored in-memory and in the binary log for replication purposes.
D. MySQL Server stores a copy of the serialized data in the InnoDB user tablespace: InnoDB tables store the serialized SDI in the InnoDB system tablespace (not in the user tablespace). This allows MySQL to recover the table structure even after a server restart.
https://dev.mysql.com/doc/refman/8.0/en/serialized-dictionary-information.html
For DDL changes. a serialized copy is kept in SDI in json format, a copy is stored in tablespace for innodb tables
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
FelipeK
2 months, 4 weeks agomarklv
3 months ago