Chevron Left Icon
Bars Icon
Product
Managed Service
Cloud Database-as-a-service
Database Software
Deploy SingleStore anywhere
Stream Icon
Ingest Data
Tools Icon
Tools and Monitoring
Lock Icon
Security
Sync Icon
Replace MySQL
Solutions
Use Cases
How SingleStore is used
Customers
Learn who uses SingleStore
Briefcase Icon
Professional Services
Industry Icon
Industries
Sitemap Icon
Architectures
Check Icon
Comparisons
Docs
Documentation
Set up and use SingleStore's products and tools
How SingleStore Works
A concise overview of SingleStore
Life Ring Icon
Support
Comments Icon
Forums
List Icon
Release Notes
Learn
Developer Hub
Begin building faster data applications
Resources
Whitepapers, ebooks, videos and more
Calendar Icon
Events
Rss Icon
Blog
Newspaper Icon
News
Presentation Icon
Training
Video Icon
Product Demo
Pricing
Envelope Icon
Envelope Icon
User Circle Icon
Laptop Icon
Portal
Access Managed Service & Licenses
Comments Icon
Forums
Ask the Community
Users Class Icon
Training
Self-Paced Learning
Life Ring Icon
Enterprise Support
Submit a Ticket
Start Free
Bars Icon
Chevron Left Icon
Bars Icon
Database Icon
Product
Analytics Icon
Solutions
Code Icon
Docs
Book Icon
Learn
Dollar Sign Icon
Pricing
User Circle Icon
Sign In
Arrow Right Icon
Start Free
Cloud Icon
Managed Service
Cloud Database-as-a-service
Database Icon
Database Software
Deploy SingleStore anywhere
Stream Icon
Ingest Data
Tools Icon
Tools and Monitoring
Lock Icon
Security
Sync Icon
Replace MySQL
Lightbulb Icon
Use Cases
How SingleStore is used
Users Icon
Customers
Learn who uses SingleStore
Briefcase Icon
Professional Services
Industry Icon
Industries
Sitemap Icon
Architectures
Check Icon
Comparisons
Book Icon
Documentation
Set up and use SingleStore's products and tools
Database Icon
How SingleStore Works
A concise overview of SingleStore
Life Ring Icon
Support
Comments Icon
Forums
List Icon
Release Notes
Laptop Icon
Developer Hub
Begin building faster data applications
File Download Icon
Resources
Whitepapers, ebooks, videos and more
Calendar Icon
Events
Rss Icon
Blog
Newspaper Icon
News
Presentation Icon
Training
Video Icon
Product Demo
Laptop Icon
Portal
Access Managed Service & Licenses
Comments Icon
Forums
Ask the Community
Users Class Icon
Training
Self-Paced Learning
Life Ring Icon
Enterprise Support
Submit a Ticket
Contact Us
Back
Latest
v7.1
v7.0
v6.8
v6.7
v6.5
v6.0
v5.8
v5.7
v5.5
v5.1
v5.0
Introduction
Documentation Overview
How MemSQL Works
FAQs
MemSQL FAQ
Support FAQ
Guides
Overview
Deploy MemSQL
Data Ingest
Development
Cluster Management
Client and Application
Security
Concepts
Concepts Overview
Distributed Architecture
Aggregator
Code Generation
Columnstore
Database
Data Skew
Distributed SQL
Full Text Search
Geospatial Guide
Indexes
Information Schema
JSON Guide
Leaf
Master Aggregator
Memory Management
MySQL Features Unsupported in MemSQL
Prepared Statements
Persistent Computed Columns
Queries
Rowstore
System Status
Table
Time Series
Unenforced Unique Constraints
Understanding Operations on Encoded Data
Window Functions Guide
Workload Management
Procedural Extensions
Pipelines
Pipelines Overview
Extractors
Transforms
Pipelines Information Schema Tables
Kafka Pipelines Overview
Kafka Pipelines Quickstart
Enabling SSL and Kerberos on Kafka Pipelines
S3 Pipelines Overview
S3 Pipelines Quickstart
Azure Blob Pipelines Overview
Azure Blob Pipelines Quickstart
Filesystem Pipelines Overview
Filesystem Pipelines Quickstart
HDFS Pipelines Overview
Workload Profiling
Workload Profiling
Workload Profiling Overview
Management View Reference
Management View Statistics Reference
Workload Profiling Scenario
Tools
Overview
MemSQL Toolbox
memsql-toolbox-config
memsql-deploy
memsql-admin
memsql-report
memsqlctl
MemSQL Studio
MemSQL Studio Overview
MemSQL Studio Installation Guide
MemSQL Studio Upgrade Guide
MemSQL Studio Architecture
MemSQL Studio CLI
MemSQL Studio Security
MemSQL Studio Resource Usage
MemSQL Studio SQL Editor
MemSQL Studio Visual Explain
MemSQL Studio WebSocket Proxy
MemSQL Client
memsql-client
MemSQL Replicate
Overview
Reference
Configuration Reference
Configuration Reference Overview
System Limits
Engine Variables
Overview
List of Engine Variables
memsql.cnf
memsqlctl
Overview
memsqlctl.hcl
nodes.hcl
Toolbox
Overview
toolbox.hcl
toolbox-state.hcl
MemSQL Ops CLI Reference
Overview
Local MemSQL Ops Agent Management
Overview
UNFOLLOW
STATUS
STOP
SSL-SET-CERT
SSL-DISABLE
API-TOKEN
AGENT-UPDATE-API-TOKEN
AGENT-ID
VERSION
UNINSTALL
START
FOLLOW
RESTART
CLUSTER-MANUAL-CONTROL
MemSQL Backup Management
Overview
DATABASE-BACKUP
AGENT-BACKUP
BACKUP-LIST
AGENT-RESTORE
DATABASE-RESTORE
BACKUP-DELETE
MemSQL License Management
Overview
LICENSE-LIST
LICENSE-ADD
MemSQL Node and Cluster Management
Overview
MEMSQL-ENABLE-HIGH-AVAILABILITY
MEMSQL-LIST
MEMSQL-OPTIMIZE
MEMSQL-PATH
MEMSQL-DEPLOY
MEMSQL-STOP
MEMSQL-UPGRADE
MEMSQL-UPDATE-ROOT-PASSWORD
MEMSQL-UPDATE-CONFIG
MEMSQL-DELETE
MEMSQL-MONITOR
MEMSQL-RESTART
MEMSQL-UNMONITOR
MEMSQL-START
MemSQL Ops File Management
Overview
FILE-DELETE
FILE-ADD
FILE-LIST
MemSQL Ops Job Management
Overview
JOB-INFO
JOB-LOGS
JOB-CANCEL
JOB-WAIT
JOB-LIST
MemSQL Ops Superuser Management
Overview
SUPERUSER-LIST
SUPERUSER-ADD
SUPERUSER-DELETE
MemSQL Ops Tools
Overview
REPORT
Remote MemSQL Ops Agent Management
Overview
AGENT-UPGRADE
AGENT-START
AGENT-UNINSTALL
AGENT-LIST
AGENT-SET-CREDENTIAL
AGENT-DEPLOY
AGENT-PUT
AGENT-SSH
AGENT-GET
AGENT-STOP
AGENT-MOVE-MEMSQL-INSTALLS-DIR
MemSQL Tools Reference
Overview
MemSQL Ops Command Mappings
Deploy MemSQL
Deploy MemSQL Offline
Deploy MemSQL via Tarball
Common Tool Commands
Overview
env
help
version
memsql-admin Commands
Overview
add-aggregator
add-leaf
bootstrap-aggregator
change-root-password
configure-monitoring
create-backup
create-node
delete-backup
delete-node
describe-node
enable-high-availability
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
start-monitoring
start-node
state
stop-monitoring
stop-node
summarize-backups
sync-ldap
unregister-node
update-config
validate-backup
memsql-deploy Commands
Overview
cluster-in-a-box
destroy-cluster
generate-cluster-file
install
list-versions
setup-cluster
state
ui
uninstall
upgrade
memsql-report Commands
Overview
check
collect-and-check
collect
collect-local
send-alert
state
memsql-toolbox-config Commands
Overview
describe-host
list-hosts
register-host
state
unregister-host
memsqlctl Commands
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
SQL Reference
Overview
Comparison Operators and Functions
Data Types
Aggregate Functions
Overview
ANY_VALUE
AVG
COUNT
GROUP_CONCAT
MAX
MIN
MOD
STD
STDDEV_SAMP
SUM
VARIANCE
VAR_SAMP
Cluster Management Commands
Overview
Node Requirements for MemSQL Commands
ADD AGGREGATOR
ADD LEAF
AGGREGATOR SET AS MASTER
ATTACH LEAF
ATTACH LEAF ALL
BOOTSTRAP AGGREGATOR
DETACH LEAF
EXPLAIN REBALANCE PARTITIONS
EXPLAIN RESTORE REDUNDANCY
FILL and FLUSH CONNECTION POOLS
FLUSH HOSTS
REBALANCE PARTITIONS
REMOVE AGGREGATOR
REMOVE LEAF
RESTORE REDUNDANCY
SHOW AGGREGATORS
SHOW LEAVES
SHOW CLUSTER STATUS
SHOW REBALANCE STATUS
TRIGGER GC
Conditional Functions
Overview
CASE
COALESCE
CONVERT
DECODE
ELT
GREATEST
IF
ISNULL
LEAST
NULLIF
NVL and IFNULL
SLEEP
Data Definition Language (DDL)
Overview
ALTER TABLE
ALTER VIEW
CREATE DATABASE
CREATE INDEX
CREATE VIEW
CREATE TABLE
DESCRIBE
DROP DATABASE
DROP INDEX
DROP ... FROM PLANCACHE
DROP TABLE
DROP VIEW
FLUSH TABLES
OPTIMIZE TABLE
TRUNCATE
UNLOCK TABLES
Data Manipulation Language (DML)
Overview
AGGREGATOR SYNC AUTO_INCREMENT
BEGIN
COMMIT
CUBE, ROLLUP and GROUPING()
DELETE
EXCEPT and MINUS
EXISTS and NOT EXISTS
EXPLAIN
INSERT
INTERSECT
LOAD DATA
PROFILE
PIVOT
REPLACE
ROLLBACK
SELECT
UNION
UPDATE
USE
WITH (Common Table Expressions)
Query Plan Operations
Date and Time Functions
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
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
WEEK
WEEKDAY
YEAR
Distinct Count Estimation Functions
Overview
APPROX_COUNT_DISTINCT
APPROX_COUNT_DISTINCT_ACCUMULATE
APPROX_COUNT_DISTINCT_COMBINE
APPROX_COUNT_DISTINCT_ESTIMATE
Full Text Search Functions
Overview
HIGHLIGHT
MATCH
Geospatial Functions
Overview
APPROX_GEOGRAPHY_INTERSECTS
GEOGRAPHY_AREA
GEOGRAPHY_CONTAINS
GEOGRAPHY_DISTANCE
GEOGRAPHY_INTERSECTS
GEOGRAPHY_LATITUDE
GEOGRAPHY_LENGTH
GEOGRAPHY_LONGITUDE
GEOGRAPHY_POINT
GEOGRAPHY_WITHIN_DISTANCE
Information Functions
Overview
CONNECTION_ID
DATABASE
LAST_INSERT_ID
ROW_COUNT
JSON Functions
Overview
JSON_ARRAY_CONTAINS_<type>
JSON_ARRAY_PUSH_<type>
JSON_DELETE_KEY
JSON_EXTRACT_<type>
JSON_GET_TYPE
JSON Keypaths
JSON_LENGTH
JSON_SET_<type>
JSON_SPLICE_<type>
Numeric Functions
Overview
ABS
SIGN
EXP
ACOS
ASIN
ATAN
ATAN2, ATAN
BIT_COUNT
bitwise AND (&)
bitwise NOT (~)
bitwise OR (|)
bitwise XOR (^)
bitwise left shift (<<)
bitwise right shift (>>)
CEIL
CONV
COS
COT
LN
LOG2
LOG10
DEGREES
FLOOR
LOG
PI
POW
RADIANS
RAND
ROUND
SIN
SQRT
TAN
TRUNCATE
Operational Commands
Overview
ANALYZE
BACKUP DATABASE
CLEAR ORPHAN DATABASES
CONTINUE REPLICATING
KILL CONNECTION
KILLALL QUERIES
PAUSE REPLICATING
REPAIR DATABASE
REPLICATE DATABASE
RESTORE
SELECT GLOBAL
SET and SET SESSION
SET GLOBAL
SHOW REPLICATION STATUS
SNAPSHOT DATABASE
STOP REPLICATING
Pipelines Commands
Overview
ALTER PIPELINE
CREATE PIPELINE
DROP PIPELINE
EXTRACT PIPELINE ... INTO OUTFILE
PROFILE PIPELINE
START PIPELINE
STOP PIPELINE
TEST PIPELINE
Procedural SQL Reference
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
Regular Expression Functions
Overview
REGEXP_INSTR
REGEXP_REPLACE
RLIKE and REGEXP
Resource Pool Commands
Overview
ALTER RESOURCE POOL
CREATE RESOURCE POOL
DROP RESOURCE POOL
SHOW RESOURCE POOLS
Security Management Commands
Overview
ALTER USER
CREATE GROUP
CREATE ROLE
CREATE USER
CURRENT_USER
DROP GROUP
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 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
SHOW Commands
Overview
SHOW CREATE PIPELINE
SHOW COLUMNS
SHOW CREATE TABLE
SHOW CREATE VIEW
SHOW DATABASES
SHOW DATABASE STATUS
SHOW ERRORS
SHOW GLOBAL STATUS
SHOW GLOBAL VARIABLES
SHOW INDEX
SHOW INDEXES
SHOW KEYS
SHOW LOAD ERRORS
SHOW LOAD WARNINGS
SHOW PIPELINES
SHOW PLANCACHE
SHOW PROCESSLIST
SHOW SCHEMAS
SHOW SESSION STATUS
SHOW SESSION VARIABLES
SHOW STATUS [EXTENDED]
SHOW TABLE STATUS
SHOW TABLES
SHOW VARIABLES
SHOW WARNINGS
String Functions
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
INSTR
LCASE
LEFT
LENGTH
LOCATE
LPAD
LTRIM
MD5
REPLACE
RIGHT
RPAD
RTRIM
SHA1
SHA2
STRING_BYTES
SUBSTRING
SUBSTRING_INDEX
TO_BASE64
TRIM
UCASE
UNHEX
Vector Functions
Overview
DOT_PRODUCT
VECTOR_SUB
EUCLIDEAN_DISTANCE
JSON_ARRAY_PACK
Window Functions
Overview
DENSE_RANK
FIRST_VALUE
LAG
LAST_VALUE
LEAD
NTH_VALUE
NTILE
PERCENT_RANK
PERCENTILE_CONT and Median
PERCENTILE_DISC
RANK
ROW_NUMBER
Troubleshooting Reference
Overview
Capacity Limit Error
Disk Capacity Errors
Memory Errors
MemSQL Tools Issues
Network Errors
Operations Errors
Query Errors
Third-Party Integrations
Introduction
Collibra
Data Virtuality Pipes
Dremio
Looker
MicroStrategy
Power BI
Sisense
Spark
StreamSets
Tableau
Talend with Open Studio
Tibco Spotfire
Zoomdata
Release Notes
MemSQL
7.1 Release Notes
7.0 Release Notes
6.8 Release Notes
6.7 Release Notes
6.5 Release Notes
6.0 Release Notes
5.8 Release Notes
5.7 Release Notes
5.5 Release Notes
5.1 Release Notes
5.0 Release Notes
4.1 Release Notes
4.0 Release Notes
3.2 Release Notes
3.1 Release Notes
MemSQL Studio
memsql-toolbox
MemSQL Ops
Outdated Version
You are viewing an older version of this section.
View current production version.
/
Deploy MemSQL
/
Deployment: Select one
Deployment: Self-Managed
/
Guide: Select one
Guide: MemSQL Tools
Guide: Cluster Configuration
/
Deployment: Select one
Deployment: Multiple Hosts
Deployment: Single Host
/
Environment: Select one
Environment: Docker
Environment: Native (Linux)
What environment do you want to run in?
Docker (Windows, macOS, Linux)
Quickly get a cluster up and running in a Docker container on Windows, macOS, and Linux.
Native (Linux)
Quickly get a cluster up and running on a Linux bare metal or virtual machine.
Was this Article Helpful?
Thanks For Your Feedback!
Need help
or have suggestions
? Go to SingleStore Forums
Was this Article Helpful?
Thanks For Your Feedback!
Sorry About That
Can you give us a little more context about what we didn’t answer for you? We’ll get back to you as soon as we can.
Question or Feedback
Please enter a valid message
Email
(if you'd like us to respond to you)
Please enter a valid email
Submit
Server error. Please try again.
Sorry About That
Can you give us a little more context about what we didn’t answer for you? We’ll get back to you as soon as we can.
Question or Feedback
Please enter a valid message
Email
(if you'd like us to respond to you)
Please enter a valid email
Submit
Server error. Please try again.