Outdated Version

You are viewing an older version of this section. View current production version.

Node Requirements for MemSQL Commands

MemSQL commands must be run on the appropriate type(s) of node in a MemSQL cluster.

  • X = recommended to run on this type of node
  • P = possible (but not recommended) to run on this type of node
  • blank = cannot run on this type of node
MemSQL Command Master Aggregator Child Aggregator Leaf
ADD AGGREGATOR X
AGGREGATOR SET AS MASTER X
ADD LEAF X X X
ALTER RESOURCE POOL X
ALTER TABLE X P
ATTACH LEAF X
BACKUP DATABASE X
BEGIN X X P
BOOTSTRAP AGGREGATOR X X
COMMIT X X P
CONTINUE REPLICATING P P P
CREATE DATABASE X P
CREATE INDEX X P
CREATE RESOURCE POOL X
CREATE TABLE X P
DELETE X X P
DESCRIBE X X X
DETACH LEAF X
DROP DATABASE X P
DROP INDEX X P
DROP RESOURCE POOL X
DROP TABLE X P
DROP USER X X X
DROP … FROM PLANCACHE X X P
EXPLAIN X X X
FLUSH TABLES X X P
GRANT X X X
INSERT X X P
KILL CONNECTION X X P
KILLALL QUERIES X X P
LOAD DATA X X P
LOCK TABLES X X P
OPTIMIZE TABLE X X P
PAUSE REPLICATING P P P
REMOVE AGGREGATOR X
REMOVE LEAF X
REPAIR DATABASE X X X
REPLACE X X P
REPLICATE DATABASE P P P
RESTORE X
RESTORE REDUNDANCY X
ROLLBACK X X P
SELECT X X P
SET GLOBAL X X P
SHOW AGGREGATORS X X
SHOW COLUMNS X X
SHOW DATABASES X X P
SHOW GRANTS X X X
SHOW INDEX X X P
SHOW INDEXES X X P
SHOW KEYS X X
SHOW LEAVES X X
SHOW PLANCACHE X X X
SHOW PROCESSLIST X X X
SHOW REPLICATION STATUS X X X
SHOW SCHEMAS X X P
SHOW GLOBAL STATUS X X X
SHOW GLOBAL VARIABLES X X X
SHOW RESOURCE POOLS X X P
SHOW SESSION STATUS X X X
SHOW SESSION VARIABLES X X X
SHOW STATUS EXTENDED X X X
SHOW TABLE STATUS X X X
SHOW TABLES X X X
SHOW VARIABLES X X X
SHOW WARNINGS X X X
SHOW ERRORS X X X
STOP REPLICATING X X X
UNLOCK TABLES X X
UPDATE X X P
USE X X P