Skip to end of metadata
Go to start of metadata

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
  • No labels