Supported Administrative SQL statements
ClustrixDB supports the following administrative SQL statements, though output may vary:
- ANALYZE TABLE
- EXPLAIN and EXPLAIN REFERENCED
- OPTIMIZE TABLE
- ClustrixDB supports the syntax for OPTIMIZE TABLE, but does not perform any operation. ClustrixDB 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 | VIEW]
- SHOW DATABASES
- SHOW ENGINES
- For compatibility, ClustrixDB lists InnoDB as part of the output of SHOW ENGINES, but the Clustrix engine will always be applied.
- Not all engines are listed as output of SHOW. See ENGINES for more information.
- 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
ClustrixDB does not support:
- CHECKSUM TABLE
- FLUSH
- SHOW AUTHORS
- SHOW BINLOG EVENTS
- SHOW CLIENT STATISTICS
- SHOW COLUMNS with WHERE clauses
- SHOW CREATE USER
- 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