Administrative Statements for MariaDB Xpand
This page is part of MariaDB's Documentation.
The parent of this page is: Administrative Statements
Topics on this page:
Supported Administrative SQL statements
Xpand supports the following administrative SQL statements, though output may vary:
ANALYZE TABLE
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 ofSHOW 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