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 LEAF X X X
AGGREGATOR SET AS MASTER X
ALTER TABLE X P
ATTACH LEAF X
ATTACH PARTITION X
BACKUP X P
BEGIN X X P
COMMIT X X P
CONTINUE REPLICATING P P P
COPY PARTITION X
CREATE DATABASE X P
CREATE INDEX X P
CREATE PARTITION X
CREATE TABLE X P
DELETE X X P
DESCRIBE X X X
DETACH LEAF X
DETACH PARTITION X
DROP DATABASE X P
DROP INDEX X P
DROP PARTITION X
DROP TABLE X P
DROP USER X X X
DROP … FROM PLANCACHE X X P
EXPLAIN X X X
EXPLAIN REBALANCE PARTITIONS 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
PAUSE REPLICATING P P P
PROMOTE PARTITION X
REBALANCE PARTITIONS 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
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 PARTITIONS X X
SHOW PLANCACHE X X X
SHOW PROCESSLIST X X X
SHOW REBALANCE STATUS 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 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
STOP REPLICATING X X X
UNLOCK TABLES X X
UPDATE X X P
USE X X P