Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Back
-
-
-
- Overview
- MemSQL Ops Command Mappings
-
- Overview
- add-aggregator
- add-leaf
- bootstrap-aggregator
- change-root-password
- configure-monitoring
- create-backup
- create-node
- delete-backup
- delete-node
- describe-node
- dump
- enable-high-availability
- enable-nodes-autostart
- list-backups
- list-nodes
- optimize
- put-file
- query
- register-node
- remove-aggregator
- remove-leaf
- restart-node
- restore-backup
- set-license
- show-aggregators
- show-leaves
- show-license
- snapshot-database
- start-monitoring
- start-node
- state
- stop-monitoring
- stop-node
- summarize-backups
- sync-ldap
- unregister-node
- update-config
- validate-backup
-
- Overview
- add-aggregator
- add-leaf
- bootstrap-aggregator
- change-root-password
- collect-garbage
- create-node
- delete-node
- describe-node
- enable-high-availability
- list-nodes
- optimize
- query
- register-node
- remove-aggregator
- remove-leaf
- restart-node
- set-license
- show-aggregators
- show-leaves
- show-license
- start-node
- stop-node
- unregister-node
- update-config
-
- Overview
- Comparison Operators and Functions
- Database Object Case-Sensitivity
- Data Types
- Operations that Take Either a Database or a Cluster Lock
- User-Defined Variables
- Restricted Keywords
-
- Overview
- Node Requirements for SingleStore DB Commands
- Leaf States
- ADD AGGREGATOR
- ADD LEAF
- AGGREGATOR SET AS MASTER
- ATTACH LEAF
- ATTACH LEAF ALL
- BOOTSTRAP AGGREGATOR
- DETACH LEAF
- EXPLAIN REBALANCE ALL DATABASES
- EXPLAIN REBALANCE PARTITIONS
- EXPLAIN RESTORE REDUNDANCY
- FILL and FLUSH CONNECTION POOLS
- FLUSH HOSTS
- PROMOTE AGGREGATOR ... TO MASTER
- REBALANCE ALL DATABASES
- REBALANCE PARTITIONS
- REMOVE AGGREGATOR
- REMOVE LEAF
- RESTORE REDUNDANCY
- SHOW AGGREGATORS
- SHOW LEAVES
- SHOW CLUSTER STATUS
- SHOW REBALANCE ALL DATABASES STATUS
- SHOW REBALANCE STATUS
- TRIGGER GC
-
- Overview
- AGGREGATOR SYNC AUTO_INCREMENT
- BEGIN
- CLEAR LOAD ERRORS
- COMMIT
- CUBE, ROLLUP and GROUPING()
- DELETE
- EXCEPT and MINUS
- EXISTS and NOT EXISTS
- EXPLAIN
- INSERT
- INTERSECT
- LOAD DATA
- PROFILE
- PIVOT
- REPLACE
- ROLLBACK
- SELECT
- TABLE
- UNION
- UPDATE
- USE
- WITH (Common Table Expressions)
- Materializing Common Table Expressions
- Query Plan Operations
-
- Overview
- ADDTIME
- CONVERT_TZ
- CURRENT_DATE And CURDATE
- CURRENT_TIME And CURTIME
- CURRENT_TIMESTAMP
- DATE
- DATEDIFF
- DATE_ADD
- DATE_FORMAT
- DATE_SUB
- DATE_TRUNC
- DAY
- DAYNAME
- DAYOFWEEK
- DAYOFYEAR
- EXTRACT
- FROM_DAYS
- FROM_UNIXTIME
- GET_FORMAT
- HOUR
- LAST_DAY
- LOCALTIMESTAMP
- MICROSECOND
- MINUTE
- MONTH
- MONTHNAME
- MONTHS_BETWEEN
- NOW
- QUARTER
- SECOND
- SEC_TO_TIME
- STR_TO_DATE
- TIME
- TIMEDIFF
- TIMESTAMP
- TIMESTAMPADD
- TIMESTAMPDIFF
- TIME_FORMAT
- TIME_TO_SEC
- TO_CHAR
- TO_DATE
- TO_DAYS
- TO_SECONDS
- TO_TIMESTAMP
- TRUNC
- UNIX_TIMESTAMP
- UTC_DATE
- UTC_TIME
- UTC_TIMESTAMP
- WEEK
- WEEKDAY
- YEAR
-
- Overview
- Statistics, Sampling, and ANALYZE
- BACKUP DATABASE
- CHECK BLOB CHECKSUM
- CLEAR ORPHAN DATABASES
- CONTINUE REPLICATING
- KILL CONNECTION
- KILLALL QUERIES
- PAUSE REPLICATING
- REPAIR DATABASE
- REPLICATE DATABASE
- RESTORE DATABASE
- SELECT GLOBAL
- SET AGGREGATOR
- SET and SET SESSION
- SET CLUSTER
- SET GLOBAL
- SET LEAF
- SHOW REPLICATION STATUS
- SNAPSHOT DATABASE
- STOP REPLICATING
-
- Overview
- Control Flow Statements
- Exceptions and Exception Handling
- MySQL Client Delimiters
- Transactions in Stored Procedures
- CREATE FUNCTION (UDF)
- CREATE FUNCTION (TVF)
- CREATE PROCEDURE
- CREATE AGGREGATE
- DROP FUNCTION
- DROP PROCEDURE
- DROP AGGREGATE
- SHOW CREATE FUNCTION
- SHOW CREATE AGGREGATE
- SHOW FUNCTIONS
- SHOW AGGREGATES
- ARRAY
- CALL
- INSERT_ALL
- CREATE_ARRAY
- COLLECT
- ECHO
- ECHO SELECT
- EXECUTE IMMEDIATE
- RECORD
- ROW
- QUERY
- SCALAR
- TO_QUERY
-
- Overview
- ALTER USER
- CREATE GROUP
- CREATE LINK
- CREATE ROLE
- CREATE USER
- CURRENT_USER
- DROP GROUP
- DROP LINK
- DROP ROLE
- DROP USER
- GRANT
- GRANT GROUP
- GRANT ROLE
- REVOKE
- REVOKE GROUP
- REVOKE ROLE
- SET PASSWORD
- SHOW GRANTS
- SHOW GROUPS
- SHOW GROUPS FOR ROLE
- SHOW GROUPS FOR USER
- SHOW LINKS
- SHOW ROLES
- SHOW ROLES FOR GROUP
- SHOW ROLES FOR USER
- SHOW USERS
- SHOW USERS FOR GROUP
- SHOW USERS FOR ROLE
- Permissions Matrix
- Default Mode Permissions Changes
- Strict Mode Permissions
-
- Overview
- SHOW CREATE PIPELINE
- SHOW COLUMNS
- SHOW CREATE TABLE
- SHOW CREATE VIEW
- SHOW DATABASES
- SHOW DATABASE STATUS
- SHOW ERRORS
- SHOW GLOBAL STATUS
- SHOW INDEX
- SHOW INDEXES
- SHOW KEYS
- SHOW LOAD ERRORS
- SHOW LOAD WARNINGS
- SHOW PIPELINES
- SHOW PLAN
- SHOW PLANCACHE
- SHOW PROCESSLIST
- SHOW SCHEMAS
- SHOW SESSION STATUS
- SHOW STATUS [EXTENDED]
- SHOW TABLE STATUS
- SHOW TABLES
- SHOW VARIABLES
- SHOW WARNINGS
- System Status
-
- Overview
- AES_DECRYPT
- AES_ENCRYPT
- ASCII
- BIN
- BINARY
- CHAR
- CHARACTER_LENGTH
- CONCAT
- CONCAT_WS
- CRC32
- FIELD
- FORMAT
- FROM_BASE64
- QUOTE
- HEX
- INET_ATON
- INET_NTOA
- INET6_ATON
- INET6_NTOA
- INITCAP
- INSTR
- LCASE
- LEFT
- LENGTH
- LOCATE
- LPAD
- LTRIM
- MD5
- REPLACE
- RIGHT
- RPAD
- RTRIM
- SHA1
- SHA2
- SPLIT
- STRING_BYTES
- SUBSTRING
- SUBSTRING_INDEX
- TO_BASE64
- TRIM
- UCASE
- UNHEX
-
- Overview
- Counting Partitions by Role
- Capacity Limit Error
- Dealing with Cluster Failures
- Disk Capacity Errors
- Diagnosing a Performance Issue using Workload Profiling
- Generating a Cluster Report
- Identifying and Reducing Memory Usage
- Memory Errors
- SingleStore Tools Issues
- Network Errors
- Operations Errors
- Query Errors
- Trace Log
- Understanding Orphaned Partitions
-
- Introduction
- Azure Data Factory (ADF)
- AWS Glue
- Collibra
- Data Virtuality Pipes
- Dremio
- HVR SingleStore Integration
- IBM Guardium Data Encryption
- Informatica Cloud
- Informatica PowerCenter
- Confluent Kafka Connector
- Looker
- MicroStrategy
- Power BI
- Qlik
- Sisense
- Spark
- StreamSets
- Tableau
- Tableau Prep
- Talend with Open Studio
- Tibco Spotfire
- Vormetric Transparent Encryption
- Zoomdata
Was this Article Helpful?
Thanks For Your Feedback!
