system Tables in Xpand

Overview

MariaDB Xpand includes system tables in the system database. When using the Xpand Storage Engine topology, the system tables described here only apply when you connect to the Xpand nodes.

Table

Description

alter_progress

Rough estimate of progress for an ALTER operation.

cluster_session_stats

Per-session statistics on transaction and statement types.

databases

Databases containing Xpand tables.

gtm_coord

Stores information on open transactions.

mysql_master_status

Information on each Replica Server that is currently connected to the Xpand service.

rebalancer_activity_log

Details on operations performed by the rebalancer process and the reason why the operation was triggered.

rebalancer_summary

Summary of current rebalancer operations.

relations

Details on Xpand tables in the deployment.

representations

Details on representations produced by each index on each Xpand table. These are the basis for data distribution through the Xpand deployment.

sessions

Information on currently connection and recently disconnected sessions.

stats

Internal statistics on database and deployment performance.

system_users

Information on database users, host, and password combinations.

table_sizes

Total size of each Xpand table.

table_slices

Information on table slices, produced by dividing representations of each Xpand table.

version_history

History of installation and upgrade versions.