Information Schema XTRADB_RSEG Table

The XTRADB_RSEG table contains detailed information about the rollback segments used by XtraDB for undo logging and MVCC.

The Information Schema XTRADB_RSEG table contains information about the XtraDB rollback segments.

The PROCESS privilege is required to view the table.

It has the following columns:

Column	Description
rseg_id	Rollback segment id.
space_id	Space where the segment is placed.
zip_size	Size in bytes of the compressed page size, or zero if uncompressed.
page_no	Page number of the segment header.
max_size	Maximum size in pages.
curr_size	Current size in pages.

The number of records will match the value set in the innodb_undo_logs variable (by default 128).

_{This page is licensed: CC BY-SA / Gnu FDL}