Back
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 TABLE X P
ATTACH LEAF X
BACKUP X P
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 TABLE X P
DELETE X X P
DESCRIBE X X X
DETACH LEAF X
DROP DATABASE X P
DROP INDEX X P
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 LOAD ERRORS X X X
SHOW LOAD WARNINGS X X X
SHOW PARTITIONS X 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 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

Questions?

Ask the Community, find solutions in the Troubleshooting Overview, get Self-Paced Training or learn more about our Support Plans.