Information Schema Tables for Xpand

Overview

MariaDB Xpand uses Information Schema tables to store information on the current operations.

Supported Views

Read-only support is available for these INFORMATION_SCHEMA views. Column definitions and results may vary from MySQL.

  • character_sets

  • collations

  • columns

  • events

  • files

  • key_column_usage

  • partitions

  • processlist

  • referential_constraints

  • routines

  • schemata

  • schema_privileges

  • statistics

  • tables

  • table_constraints

  • table_privileges

  • triggers

  • user_privileges

  • views

Unsupported Views

Xpand does not support these objects:

  • collation_character_set_applicability

  • column_privileges

  • engines

  • global_status

  • global_variables

  • nbd_transid_mysql_connection_map

  • optimizer_trace

  • parameters

  • plugins

  • profiling

  • session_status

  • session_variables

  • tablespaces

Xpand-Specific Views

The follow are views specific to Xpand:

Table

Description

clx_function_privileges

Function privileges granted to users.

clx_procedure_privileges

Procedure privileges granted to users.

global_variables_with_defaults

Current Xpand global variable settings and their default values.