# Workspace Management Commands ## Node Requirements for SingleStore Helios Commands SingleStore Helios commands must be run on the appropriate type(s) of node in a SingleStore Helios workspace. When `sync_permissions` and `enable_query_forwarding` are set to `ON`, all Data Definition Language (DDL) commands can be forwarded from child aggregator to master. This list of requirements reflects this behavior. * 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 | SingleStore HeliosCommand | Master Aggregator | Child Aggregator | Leaf | | --------------------------------------------------------------------------------------------------------------------------------------- | ----------------- | ---------------- | ---- | | [ANALYZE](https://docs.singlestore.com/cloud/reference/sql-reference/operational-commands/analyze.md) | X | X | | | [ALTER DATABASE](https://docs.singlestore.com/cloud/reference/sql-reference/data-definition-language-ddl/alter-database.md) | X | X | | | [ALTER RESOURCE POOL](https://docs.singlestore.com/cloud/reference/sql-reference/resource-pool-commands/alter-resource-pool.md) | X | X | | | [ALTER TABLE](https://docs.singlestore.com/cloud/reference/sql-reference/data-definition-language-ddl/alter-table.md) | X | X | P | | [ALTER VIEW](https://docs.singlestore.com/cloud/reference/sql-reference/data-definition-language-ddl/alter-view.md) | X | X | P | | [ALTER USER](https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands/alter-user.md) | X | X | | | [ALTER PIPELINE](https://docs.singlestore.com/cloud/reference/sql-reference/pipelines-commands/alter-pipeline.md) | X | X | | | [BACKUP DATABASE](https://docs.singlestore.com/cloud/reference/sql-reference/operational-commands/backup-database.md) | X | X | | | [BEGIN](https://docs.singlestore.com/cloud/reference/sql-reference/data-manipulation-language-dml/begin.md) | X | X | P | | [COMMIT](https://docs.singlestore.com/cloud/reference/sql-reference/data-manipulation-language-dml/commit.md) | X | X | P | | [CREATE AGGREGATE](https://docs.singlestore.com/cloud/reference/sql-reference/procedural-sql-reference/create-aggregate.md) | X | X | | | [CREATE DATABASE](https://docs.singlestore.com/cloud/reference/sql-reference/data-definition-language-ddl/create-database.md) | X | X | P | | [CREATE FUNCTION](https://docs.singlestore.com/cloud/reference/sql-reference/procedural-sql-reference/create-function-udf.md) | X | X | | | [CREATE GROUP](https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands/create-group.md) | X | X | | | [CREATE INDEX](https://docs.singlestore.com/cloud/reference/sql-reference/data-definition-language-ddl/create-index.md) | X | X | P | | [CREATE PIPELINE](https://docs.singlestore.com/cloud/reference/sql-reference/pipelines-commands/create-pipeline.md) | X | X | | | [CREATE PROCEDURE](https://docs.singlestore.com/cloud/reference/sql-reference/procedural-sql-reference/create-procedure.md) | X | X | | | [CREATE RESOURCE POOL](https://docs.singlestore.com/cloud/reference/sql-reference/resource-pool-commands/create-resource-pool.md) | X | X | | | [CREATE ROLE](https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands/create-role.md) | X | X | | | [CREATE TABLE](https://docs.singlestore.com/cloud/reference/sql-reference/data-definition-language-ddl/create-table.md) | X | X | P | | [CREATE USER](https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands/create-user.md) | X | X | | | [CREATE VIEW](https://docs.singlestore.com/cloud/reference/sql-reference/data-definition-language-ddl/create-view.md) | X | X | | | [DELETE](https://docs.singlestore.com/cloud/reference/sql-reference/data-manipulation-language-dml/delete.md) | X | X | P | | [DESCRIBE](https://docs.singlestore.com/cloud/reference/sql-reference/data-definition-language-ddl/describe.md) | X | X | X | | [DROP AGGREGATE](https://docs.singlestore.com/cloud/reference/sql-reference/procedural-sql-reference/drop-aggregate.md) | X | X | | | [DROP DATABASE](https://docs.singlestore.com/cloud/reference/sql-reference/data-definition-language-ddl/drop-database.md) | X | X | P | | [DROP FUNCTION](https://docs.singlestore.com/cloud/reference/sql-reference/procedural-sql-reference/drop-function.md) | X | X | | | [DROP GROUP](https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands/drop-group.md) | X | X | | | [DROP INDEX](https://docs.singlestore.com/cloud/reference/sql-reference/data-definition-language-ddl/drop-index.md) | X | X | P | | [DROP PIPELINE](https://docs.singlestore.com/cloud/reference/sql-reference/pipelines-commands/drop-pipeline.md) | X | X | | | [DROP PROCEDURE](https://docs.singlestore.com/cloud/reference/sql-reference/procedural-sql-reference/drop-procedure.md) | X | X | | | [DROP RESOURCE POOL](https://docs.singlestore.com/cloud/reference/sql-reference/resource-pool-commands/drop-resource-pool.md) | X | X | | | [DROP ROLE](https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands/drop-role.md) | X | X | | | [DROP TABLE](https://docs.singlestore.com/cloud/reference/sql-reference/data-definition-language-ddl/drop-table.md) | X | X | P | | [DROP USER](https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands/drop-user.md) | X | X | X | | [DROP VIEW](https://docs.singlestore.com/cloud/reference/sql-reference/data-definition-language-ddl/drop-view.md) | X | X | P | | [DROP … FROM PLANCACHE](https://docs.singlestore.com/cloud/reference/sql-reference/data-definition-language-ddl/drop-from-plancache.md) | X | X | P | | [EXPLAIN](https://docs.singlestore.com/cloud/reference/sql-reference/data-manipulation-language-dml/explain.md) | X | X | X | | [FLUSH TABLES](https://docs.singlestore.com/cloud/reference/sql-reference/data-definition-language-ddl/flush-tables.md) | X | | P | | [GRANT](https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands/grant.md) | X | X | X | | [GRANT GROUP](https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands/grant-group.md) | X | X | X | | [GRANT ROLE](https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands/grant-role.md) | X | X | X | | [INSERT](https://docs.singlestore.com/cloud/reference/sql-reference/data-manipulation-language-dml/insert.md) | X | X | P | | [KILL CONNECTION](https://docs.singlestore.com/cloud/reference/sql-reference/operational-commands/kill-connection-and-kill-query.md) | X | X | P | | [KILLALL QUERIES](https://docs.singlestore.com/cloud/reference/sql-reference/operational-commands/killall-queries.md) | X | X | P | | [LOAD DATA](https://docs.singlestore.com/cloud/reference/sql-reference/data-manipulation-language-dml/load-data.md) | X | X | P | | [OPTIMIZE TABLE](https://docs.singlestore.com/cloud/reference/sql-reference/data-definition-language-ddl/optimize-table.md) | X | X | P | | [PROFILE PIPELINE](https://docs.singlestore.com/cloud/reference/sql-reference/pipelines-commands/profile-pipeline.md) | X | X | | | [REPAIR DATABASE](https://docs.singlestore.com/cloud/reference/sql-reference/operational-commands/repair-database.md) | X | X | X | | [REPLACE](https://docs.singlestore.com/cloud/reference/sql-reference/data-manipulation-language-dml/replace.md) | X | X | P | | [RESTORE DATABASE](https://docs.singlestore.com/cloud/reference/sql-reference/operational-commands/restore-database.md) | X | X | | | [ROLLBACK](https://docs.singlestore.com/cloud/reference/sql-reference/data-manipulation-language-dml/rollback.md) | X | X | P | | [REVOKE](https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands/revoke.md) | X | X | | | [REVOKE GROUP](https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands/revoke-group.md) | X | X | | | [REVOKE ROLE](https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands/revoke-role.md) | X | X | | | [SELECT](https://docs.singlestore.com/cloud/reference/sql-reference/data-manipulation-language-dml/select.md) | X | X | P | | [SHOW COLUMNS](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-columns.md) | X | X | | | [SHOW CREATE TABLE](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-create-table.md) | X | X | P | | [SHOW DATABASES](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-databases.md) | X | X | P | | [SHOW GRANTS](https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands/show-grants.md) | X | X | X | | [SHOW INDEX](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-index-show-indexes-show-keys.md) | X | X | P | | [SHOW INDEXES](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-index-show-indexes-show-keys.md) | X | X | P | | [SHOW KEYS](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-index-show-indexes-show-keys.md) | X | X | | | [SHOW PLANCACHE](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-plancache.md) | X | X | X | | [SHOW PROCESSLIST](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-processlist.md) | X | X | X | | [SHOW REPLICATION STATUS](https://docs.singlestore.com/cloud/reference/sql-reference/operational-commands/show-replication-status.md) | X | X | X | | [SHOW SCHEMAS](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-schemas.md) | X | X | P | | [SHOW GLOBAL STATUS](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-global-status.md) | X | X | X | | [SHOW GLOBAL VARIABLES](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-variables.md) | X | X | X | | [SHOW RESOURCE POOLS](https://docs.singlestore.com/cloud/reference/sql-reference/resource-pool-commands/show-resource-pools.md) | X | X | P | | [SHOW SESSION STATUS](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-session-status.md) | X | X | X | | [SHOW SESSION VARIABLES](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-variables.md) | X | X | X | | [SHOW STATUS EXTENDED](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-status-extended.md) | X | X | X | | [SHOW TABLE STATUS](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-table-status.md) | X | X | X | | [SHOW TABLES](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-tables.md) | X | X | X | | [SHOW VARIABLES](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-variables.md) | X | X | X | | [SHOW WARNINGS](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-warnings.md) | X | X | X | | [SHOW ERRORS](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-errors.md) | X | X | X | | [START PIPELINE](https://docs.singlestore.com/cloud/reference/sql-reference/pipelines-commands/start-pipeline.md) | X | X | | | [STOP PIPELINE](https://docs.singlestore.com/cloud/reference/sql-reference/pipelines-commands/stop-pipeline.md) | X | X | | | [TRUNCATE](https://docs.singlestore.com/cloud/reference/sql-reference/data-definition-language-ddl/truncate.md) | X | X | | | [UNLOCK TABLES](https://docs.singlestore.com/cloud/reference/sql-reference/data-definition-language-ddl/unlock-tables.md) | X | | | | [UPDATE](https://docs.singlestore.com/cloud/reference/sql-reference/data-manipulation-language-dml/update.md) | X | X | P | | [USE](https://docs.singlestore.com/cloud/reference/sql-reference/data-manipulation-language-dml/use.md) | X | X | P | ## Leaf States Each leaf is in one of the following states: | State | Description | | ------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | `Unknown` | In this state, a leaf is not part of theworkspace. | | `Online` | This is the default, healthy state of a leaf. In the`online`state, the leaf is an active member of the distributed system and is either currently serving or ready to serve data to the aggregators. | | `Offline` | The master aggregator periodically sends a heartbeat (ping) to all the nodes in aworkspaceto determine if they are responsive and online. A leaf enters the`offline`state if the master aggregator cannot reach it. The heartbeat frequency is based on typical network latencies and node responsiveness. It is set to a default of 150ms which has been empirically determined.If theworkspaceis in redundancy 2 any partitions on the`offline`node will be failed over to the leaves pair. The master aggregator continues to ping`offline`nodes to detect when they should be moved into the`attaching`state. | | `Recovering` | Not online, and not available for read or write queries. A leaf in`recovering`state has been restarted and is replaying data back into memory. | | `Detached` | In this state, the leaf is detached from theworkspace. | | `Attaching` | A leaf transitions from`offline`to`attaching`when it is once again reachable by heartbeats. | The following diagram summarizes the leaf states and the transitions between them. ![](https://images.contentstack.io/v3/assets/bltac01ee6daa3a1e14/blt4f2b0cf749e87065/6a3e76f822080ec81aeef2a6/16083b57986b1b-09mRrb.png) ## In this section * [EXPLAIN RESTORE REDUNDANCY](https://docs.singlestore.com/cloud/reference/sql-reference/workspace-management-commands/explain-restore-redundancy.md) * [FLUSH EXTRACTOR POOLS](https://docs.singlestore.com/cloud/reference/sql-reference/workspace-management-commands/flush-extractor-pools.md) * [FLUSH HOSTS](https://docs.singlestore.com/cloud/reference/sql-reference/workspace-management-commands/flush-hosts.md) * [SHOW AGGREGATORS](https://docs.singlestore.com/cloud/reference/sql-reference/workspace-management-commands/show-aggregators.md) *** Modified at: November 18, 2025 Source: [/cloud/reference/sql-reference/workspace-management-commands/](https://docs.singlestore.com/cloud/reference/sql-reference/workspace-management-commands/) (An index of the documentation is available at /llms.txt)