February 2018
Intermediate to advanced
510 pages
16h 10m
English
This is a utility program that extracts serialized dictionary information from InnoDB tablespace files. Serivalized dictionary information that is SDI data will always be present in all persistent InnoDB tablespace files. It can be run on file-per-table on tablespace files and general tablespace files, system tablespace files, and data dictionary tablespace files, but using a temporary tablespace or undoing a tablespace is not supported.
ibd2sdi can be used while the server is offline or at runtime. It reads uncommitted data of SDI from a specified tablespace and undoes logs and redoes logs that are not accessible.
Execution for the idb2sdi will look like the following command line:
shell> ...
Read now
Unlock full access