Node requirement for MemSQL commands

October 20, 2014 · by · in MemSQL

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

Please refer the link MemSQL Commands by Type — MemSQL 2.6 documentation for more details.

  • 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
CHECK TABLE X X X
CONTINUE REPLICATING P P P
COPY PARTITION X
CREATE DATABASE X P
CREATE INDEX X P
CREATE PARTITION X
CREATE SCHEMA X P
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 SCHEMA X P
DROP TABLE X P
DROP USER X X X
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
KILL QUERY X X P
LOAD DATA X X P
LOCK TABLES X X P
OPTIMIZE TABLE P P X
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
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 P
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 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

  • Ask Question