Skip to main content

execute

Function execute 

Source
pub fn execute(
    opts: &PagesOptions,
    writer: &mut dyn Write,
) -> Result<(), IdbError>
Expand description

Perform deep structural analysis of pages in an InnoDB tablespace.

Unlike parse which only decodes FIL headers, this command dives into page-type-specific internal structures:

  • INDEX pages (type 17855): Decodes the index header (index ID, B+Tree level, record counts, heap top, garbage bytes, insert direction), FSEG inode pointers for leaf and non-leaf segments, and infimum/supremum system record metadata.
  • UNDO pages (type 2): Shows the undo page header (type, start/free offsets, used bytes) and segment header (state, last log offset).
  • BLOB/ZBLOB pages (types 10, 11, 12): Shows data length and next-page chain pointer for old-style externally stored columns.
  • LOB_FIRST pages (MySQL 8.0+): Shows version, flags, total data length, and transaction ID for new-style LOB first pages.
  • Page 0 (FSP_HDR): Shows extended FSP header fields including compression algorithm, encryption flags, and first unused segment ID.

In list mode (-l), output is a compact one-line-per-page summary showing page number, type, description, and byte offset. In detail mode (the default), each page gets a full multi-section breakdown. Use -t to filter by page type name (supports aliases like “undo”, “blob”, “lob”, “sdi”, “compressed”, “encrypted”).