Administrative Statements for MariaDB Xpand

Supported Administrative SQL statements

Xpand supports the following administrative SQL statements, though output may vary:

  • ANALYZE TABLE

  • EXPLAIN and EXPLAIN REFERENCED

  • OPTIMIZE TABLE

    • Xpand supports the syntax for OPTIMIZE TABLE, but does not perform any operation. Xpand uses background processes to automatically optimize storage.

  • REPAIR TABLE

  • SHOW BINARY LOGS

  • SHOW CHARACTER SET (with no WHERE clause)

  • SHOW COLLATION

  • SHOW COLUMNS

  • SHOW CREATE [DATABASE | TABLE | FUNCTION | TRIGGER | SEQUENCE | | USER | VIEW]

  • SHOW DATABASES

  • SHOW ENGINES

    • For compatibility, Xpand lists InnoDB as part of the output of SHOW ENGINES, but the Xpand engine will always be applied.

    • Not all engines are listed as output of SHOW. For additional information, see "ENGINE Table Option for MariaDB Xpand".

  • SHOW GRANTS

  • SHOW INDEX

  • SHOW MASTER STATUS

  • SHOW OPEN TABLES

  • SHOW PROCESSLIST

  • SHOW SLAVE HOSTS

  • SHOW STATUS

  • SHOW TABLES

  • SHOW TRIGGER

  • SHOW WARNINGS

    • The syntax for SHOW WARNINGS is supported, but no warnings are ever displayed.

  • SHOW VARIABLES

Unsupported Administrative SQL statements

Xpand does not support:

  • CHECKSUM TABLE

  • FLUSH

  • SHOW AUTHORS

  • SHOW BINLOG EVENTS

  • SHOW CLIENT STATISTICS

  • SHOW CONTRIBUTORS

  • SHOW ERRORS

  • SHOW EVENTS

  • SHOW EXPLAIN FOR

  • SHOW FUNCTION [CODE | STATUS]

  • SHOW INDEX STATISTICS

  • SHOW LOCALES

  • SHOW MASTER LOGS

  • SHOW PLUGINS

  • SHOW PRIVILEGES

  • SHOW PROFILE

  • SHOW PROCEDURE [CODE | STATUS]

  • SHOW QUERY_RESPONSE_TIME

  • SHOW TABLE_STATISTICS

  • SHOW USER_STATISTICS