# Information Schema XTRADB\_RSEG Table

The [Information Schema](https://mariadb.com/docs/server/reference/system-tables/information-schema) `XTRADB_RSEG` table contains information about the XtraDB rollback segments.

The `PROCESS` [privilege](https://mariadb.com/docs/server/reference/sql-statements/account-management-sql-statements/grant) 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](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_undo_logs) variable (by default 128).

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}